Re: Getting NLS_DATE_FORMAT to work with MM/DD/RR parameter

From: Van Messner <vmessner_at_netaxis.com>
Date: Fri, 13 Nov 1998 18:18:21 -0500
Message-ID: <fa332.788$KL3.5769@news14.ispnews.com>

Gerald:

The others gave you good advice. You might consider using MM/DD/RRRR which works much as RR but handles four digit years gracefully.

Van

Gerald M. Lewis wrote in message <364c5d37.1058009_at_nntp.ix.netcom.com>...
>I would like to have the database either roll-up or roll-down the
>century on date columns. From what I have read, it appears that the
>NLS_DATE_FORMAT initialization parameters allows you to to this. I
>have modified the INITORCL.ORA file to include the following:
>
>NLS_DATE_FORMAT = "MM/DD/RR"
>
>I have tried several other combinations with no success. Anytime I
>insert a date, e.g, 11/13/02, I get 11/13/1902. What am I doing
>wrong? Any help would be greatly appreciated. Thanks in advance.
>
>Gerald M. Lewis
>Senior Systems Expert
>HAZMED, Inc.
Received on Fri Nov 13 1998 - 17:18:21 CST