Re: Oracle Date datatype Y2K Issues

From: Diego Pafumi <dpafumi_at_us.oracle.com>
Date: Tue, 17 Nov 1998 07:42:51 -0800
Message-ID: <3651997B.FA391E8@us.oracle.com>

Sorry, but is not sufficient. Also you have to correct all your programs and modified the date fields to yyyy or RR. Good Luck !!!

Sanjay Hans wrote:

> Would appreciate your suggestions on Oracle Date datatype Y2K issue.
>
> Is it sufficient to issue the following commands to ensure that all the
> date datatype fields in
> the database are Y2K compliant:
> alter session set nls_date_format ='DD-MON-YYYY' for each connection to
> Oracle session and then insert/ update the date fields in the tables.
> Or I should use 'DDMMRR' format to insert/update values in the date
> datatype fields.
>
> Thanks in advance.
Received on Tue Nov 17 1998 - 09:42:51 CST