No, there is no add_century function. However, there IS an add_months function. So if you need to back up all of your dates by 100 years, then you could try:
UPDATE my_table SET dob = add_months(dob, -1200);
|
Results 1 to 2 of 2
Thread: Y2K Date IssueThreaded View
|
Click Here to Expand Forum to Full Width |