Tuesday, October 09, 2007

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!

No comments: