Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!logbridge.uoregon.edu!news-west.eli.net!not-for-mail
Message-ID: <3CC96EBA.D877603F@exesolutions.com>
From: Daniel Morgan <damorgan@exesolutions.com>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.tools
Subject: Re: Date question ? Please Help
References: <bf25b803.0204260415.40c9356a@posting.google.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 23
Date: Fri, 26 Apr 2002 15:14:05 GMT
NNTP-Posting-Host: 156.74.250.7
X-Complaints-To: yvonne.tracy@ci.seattle.wa.us
X-Trace: news-west.eli.net 1019834045 156.74.250.7 (Fri, 26 Apr 2002 09:14:05 MDT)
NNTP-Posting-Date: Fri, 26 Apr 2002 09:14:05 MDT
Organization: City of Seattle NewsReader Service
Xref: easynews comp.databases.oracle.tools:50963
X-Received-Date: Fri, 26 Apr 2002 08:11:43 MST (news.easynews.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