Re: Date question ? Please Help
From: Eric J. Givler <ericjgivler_at_earthlink.net>
Date: Sat, 27 Apr 2002 01:42:19 GMT
Message-ID: <%lny8.7346$iU4.588376_at_newsread2.prod.itd.earthlink.net>
Date: Sat, 27 Apr 2002 01:42:19 GMT
Message-ID: <%lny8.7346$iU4.588376_at_newsread2.prod.itd.earthlink.net>
use a format example next to the sql*loader column, ie: mydate "to_date(:mydate,'MM/DD/YY')"
"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 Sat Apr 27 2002 - 03:42:19 CEST