Re: Y2K Date Issues with Oracle 7.3.4
Date: Thu, 13 Jan 2000 15:30:08 -0800
Message-ID: <85lnet$lki$1_at_plo.sierra.com>
[Quoted] We simply use 'YYYY' in all date conversions
to_date('01-JAN-1999','DD-MON-YYYY')
and
to_char(sysdate,'DD-MON-YYYY')
Mungo Henning <mungoh_at_itacs.strath.ac.uk> wrote in message
news:387DE3D7.B44F28B1_at_itacs.strath.ac.uk...
>
>
> James Lorenzen wrote:
>
> > [good stuf snipped]
>
> Just a little warning: remember that the RR format is fine for "recent"
> dates,
> but if you have anyone born before 1950 (data for insurance policies etc)
> then the RR format will give you grief when it interprets "49" as "2049".
>
> Mungo
>
> --
> Mungo Henning - it's a daft name but it goes with the face...
> mungoh_at_itacs.strath.ac.uk.http://www.itacs.strath.ac.uk/
> I speak for me, not my employer.
>
>
Received on Fri Jan 14 2000 - 00:30:08 CET