Re: Date question ? Please Help

"wilson" <wswwong_at_hotmail.com> wrote in message news:bf25b803.0204260932.16bd0e91_at_posting.google.com...
> wswwong_at_hotmail.com (wilson) 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.
>
>
> Pls note that I understand the RR format of the year but if the year
> is between 00 - 49 then Oracle will assume the year to be 20xx,
what
> I really want to do is to set the year to be 19YY (that is insert
> '19' in front of the year) during sqlload, any idea ? Thanks

You might consider writing a simple Unix filter to massage your data: perl, gawk, sed, etc will do the trick. If you're on a Windows machine, consider the free CYGWIN bits.

--
Pablo Sanchez, High-Performance Database Engineering
mailto:pablo_at_hpdbe.com
Available for short-term and long-term contracts