Re: Date question ? Please Help
Date: 26 Apr 2002 13:27:42 -0700
Message-ID: <336da121.0204261227.2c17ba4_at_posting.google.com>
wswwong_at_hotmail.com (wilson) wrote in message news:<bf25b803.0204260415.40c9356a_at_posting.google.com>...
Use format 'MM/DD/RR'. It defaults to 19YY if year > 49 and to 20YY if year <=49. If you need all your dates in 20th century, use sql statement to convert your string. YY format for the year defaults to the current century.
> 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 - 22:27:42 CEST