Re: 2 digit date problem

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 25 Jan 2000 23:05:11 +0100
Message-ID: <948838027.8499.0.pluto.d4ee154e@news.demon.nl>

use dd-mon-rr as date mask.

Hth,

--
Sybrand Bakker, Oracle DBA
Darren Brock <brock_at_governet.net> wrote in message news:388E199F.8DA8172E_at_governet.net...
> Hi
> We receive a 'lot' of data from clients and we recently noticed that
> some of them are giving us 2 digit years. Oracle is tacking '20' onto
> the front to make them '2000'. the problem is that most of the dates are
> supposed to be '19xx' and we get '2099' etc. instead. I thought Oracle
> had a mechanism that when receiving a 2 digit year put 19 on if the 2
> digit year was greater than thirty? I am obviously wrong. Any ideas on
> how I can rectify this so it is taken care of during the loads?
>
> Oracle 8.0.4 on Sun Sparc, Solaris
>
> Darren
Received on Tue Jan 25 2000 - 16:05:11 CST