Re: Date question ? Please Help

From: Keld Nielsen <keldnielsen_at_image.dk>
Date: Fri, 26 Apr 2002 20:23:56 +0200
Message-ID: <b%gy8.4415$kp3.352296_at_news010.worldonline.dk>


select to_char(to_date('02/15/54','MM/DD/RR'),'dd-mon-yyyy') from dual 15-feb-1954

select to_char(to_date('02/15/54','MM/DD/YY'),'dd-mon-yyyy') from dual 15-feb-2054

select to_char(to_date('02/15/54','MM/DD/RR'),'dd-mon-rrrr') from dual 15-feb-1954

select to_char(to_date('02/15/54','MM/DD/YY'),'dd-mon-rrrr') from dual 15-feb-2054

personal 9.0.1.1.1 on ME - not certified I know I know !

regards,
Keld

"wilson" <wswwong_at_hotmail.com> wrote in message news:bf25b803.0204260415.40c9356a_at_posting.google.com...
> My input data for date is in this format MM/DD/YY for example
> 02/15/54, please note that the year is actually 1954. I use the
> sql*loader with this datatype DATE 'MM/DD/YY'; now after loading I do
> this "select to_char(mydate, 'yyyy') from mytable" Oracle returns
> 2054. Question what do I need to specify for the Date during
> sqlloader to tell oracle the year is 19YY and not 20YY ? Please help.
> Thanks in advance.
Received on Fri Apr 26 2002 - 20:23:56 CEST

Original text of this message