Tuesday, October 09, 2007

oracle update and display datetime in Date datatype fields

update class_schedule set start_time = to_date('2003-06-13 15:18','YYYY-MM-DD HH24:MI') where id=17

select to_char(start_time,'YYYY-MM-DD HH24:MI') from class_schedule where id=17;

No comments: