Re: Oracle Date datatype Y2K Issues

From: Van Messner <vmessner_at_netaxis.com>
Date: Tue, 17 Nov 1998 19:57:53 -0500
Message-ID: <x%o42.658$G27.4642@news6.ispnews.com>

You have a lot more work than that. Oracle stores the dates correctly IF you enter them correctly. Any programs which employ date arithmetic need to be checked. As an intermediate step, if you are considering any kind of RR, take a look at RRRR which gives you more flexibility.

Van

Sanjay Hans wrote in message <01be1237$8f47c820$40cb15a5_at_oempre-install>...
>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 - 18:57:53 CST