Date question ? Please Help
From: wilson <wswwong_at_hotmail.com>
Date: 26 Apr 2002 05:15:51 -0700
Message-ID: <bf25b803.0204260415.40c9356a_at_posting.google.com>
[Quoted] [Quoted] My input data for date is in this format MM/DD/YY for example [Quoted] [Quoted] 02/15/54, please note that the year is actually 1954. I use the [Quoted] [Quoted] sql*loader with this datatype DATE 'MM/DD/YY'; now after loading I do [Quoted] [Quoted] this "select to_char(mydate, 'yyyy') from mytable" Oracle returns [Quoted] 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 - 14:15:51 CEST
Date: 26 Apr 2002 05:15:51 -0700
Message-ID: <bf25b803.0204260415.40c9356a_at_posting.google.com>
[Quoted] [Quoted] My input data for date is in this format MM/DD/YY for example [Quoted] [Quoted] 02/15/54, please note that the year is actually 1954. I use the [Quoted] [Quoted] sql*loader with this datatype DATE 'MM/DD/YY'; now after loading I do [Quoted] [Quoted] this "select to_char(mydate, 'yyyy') from mytable" Oracle returns [Quoted] 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 - 14:15:51 CEST