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

I think you are doing good. But first i need to know how is the format where you storage that value, that format must be 'rr' too.

Gerald M. Lewis wrote:

> 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 - 10:54:48 CST