Re: How to make Oracle 7.3.4.x.x display "DD-MON-YYYY" not "DD-MON-YY"

From: TurkBear <johng_at_nospam.mm.com>
Date: Fri, 23 Apr 1999 16:05:48 GMT
Message-ID: <37219a34.8881390@news.dot.state.mn.us>

There are 2 ( at least) ways to insure this: In your initorcl.ota files add:

nls_date_format ="DD-MON-YYYY"

Bounce the database and it will use this format when returning dates ( if no format specification is supplied )
 HOWEVER: IF the client ( Nt or Win95 or whatever ) has ANY NLS_ settings in the registry or environment, then the client settings will supplant the settings in your initorcl.ora file and it will substitute the Oracle DEFAULT values for all non-specified NLS_ parameters,,,,therefore if NLS_DATE_FORMAT is not set in the registry and some other NLS_ is set, then the date will be returned in 'MM-DD-YY' format; so
either remove all NLS_ parameters on the client, or make sure the NLS_DATE_FORMAT is set to the same value as the initorcl.ora file...

Hope it helps...

adrianh_at_globalnet.co.uk (Adrian Harrison) wrote:

>I have 2 Oracle 7.3.4.x.x databases, one is personal Oracle and the other Oracle server running on a
>NT 4 server box.
>
>Although they are supposed to be Y2K compliant whenever I execute a statement like "select sysdate
>from dual" I get the system date back in "DD-MON-YY" format!
>
>How do I specify that I want it in "DD-MON-YYYY" format. By the way my windows date setting have the
>year set to "YYYY"
>

snipped initorcl.ora file ---------------------

>
>
>Any ideas
>
>Thanks
>
>Adrian Harrison
>
>
>
>

To reply please remove the 'nospam' part of the address Received on Fri Apr 23 1999 - 11:05:48 CDT