I created this, do you know what it does?
update class_schedule set start_time= add_months(start_time, -12*
(select to_number(to_char(start_time,'yyyy')-2006) from dual)) where
to_char(start_time,'yyyy')> to_char(2006)
GOOD LUCK!
Achievement provides the only real pleasure in life
update class_schedule set start_time= add_months(start_time, -12*
(select to_number(to_char(start_time,'yyyy')-2006) from dual)) where
to_char(start_time,'yyyy')> to_char(2006)
GOOD LUCK!
Posted by SF at 2:02 am
No comments:
Post a Comment