Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Adding 1900 years to a date
Have a load of dates in an 8i (8.1.7.2) database inadvertently loaded as
e.g.
21-sep-0076
i..e with the wrong century. What is quickest way of adding the 1900 years to each of these?
-- jeremyReceived on Mon Aug 30 2004 - 13:37:29 CDT