oracle8.1.6
update blocks_course_mode
set course_mode = :course_mode, number_of_blocks = :number_of_blocks,
start_date = (select to_date(:start_date, 'YYYY MM DD HH24 MI SS') from dual)
where community_id = :community_id
select course_mode, number_of_blocks,
to_char(start_date,'YYYY MM DD') start_date
from blocks_course_mode
where community_id = :community_id