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;
Achievement provides the only real pleasure in life
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;
Posted by SF at 12:08 am
No comments:
Post a Comment