Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Adding 1900 years to a date

Adding 1900 years to a date

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Mon, 30 Aug 2004 19:37:29 +0100
Message-ID: <MPG.1b9d84434264ec58989ccf@news.individual.net>


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?

-- 

jeremy
Received on Mon Aug 30 2004 - 13:37:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US