Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't change the nls_date_format!

Re: Can't change the nls_date_format!

From: Van Messner <vmessner_at_netaxis.com>
Date: Wed, 13 May 1998 12:07:29 -0400
Message-ID: <6jcggp$akl$1@news6.ispnews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US