Re: Date question ? Please Help

wswwong_at_hotmail.com (wilson) 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.

[Quoted] Pls note that I understand the RR format of the year but if the year is between 00 - 49 then Oracle will assume the year to be 20xx, what [Quoted] I really want to do is to set the year to be 19YY (that is insert '19' in front of the year) during sqlload, any idea ? Thanks Received on Fri Apr 26 2002 - 19:32:45 CEST