Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can't change the nls_date_format!
We're going to YYYY. But while we get everything else into compliance
RRRR seems to be a good intermediate step. On our version of Oracle
7.2 I haven't found any problems.
Van
Suresh Bhat wrote in message <01bd7cfa$3797b7c0$a504fa80_at_mndnet>...
>If you are going to 4 digit format, it is better to use 'YYYY'. This has
>always worked. In some older 7.xxx releases 'RRRR' did not work properly.
>i.e it gave 9898 rather than 1998 and bombed.
>
>Van Messner <vmessner_at_netaxis.com> wrote in article
><6iqjd7$fs5$1_at_news7.ispnews.com>...
>> If you're thinking of changing to 'RR' take a look at 'RRRR'. For some
>> installations it offers the best of both worlds.
>> Van
>
>snip
>
Received on Wed May 13 1998 - 11:07:29 CDT