Re: Date question ? Please Help
From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Fri, 26 Apr 2002 15:14:05 GMT
Message-ID: <3CC96EBA.D877603F_at_exesolutions.com>
Date: Fri, 26 Apr 2002 15:14:05 GMT
Message-ID: <3CC96EBA.D877603F_at_exesolutions.com>
wilson wrote:
> 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.
Try this:
CREATE TABLEe xyz (
test date);
INSERT INTO xyz
VALUES
(TO_DATE('02/15/54', 'MM/DD/RR'));
SELECT TO_CHAR(test, 'DD-MON-YYYY') from xyz;
Daniel Morgan Received on Fri Apr 26 2002 - 17:14:05 CEST