Re: Setting initXXXX.ora nls_date_format

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 25 Feb 1999 00:14:20 GMT
Message-ID: <36d4955f.3483433@news.arnes.si>

On Wed, 24 Feb 1999 16:21:49 GMT, "Oracleguru, Suresh Bhat" <oracleguru_at_mailcity.com> wrote:

>Hi !
>
>I set nls_date_format = 'dd-MON-rr' in the initXXXX.ora file. Now when I
>retrieve a date column from a table I get results with single quotes around
>it:
>
> ...[SNIP]...
>
>Is it
>
> nls_date_format = "dd-MON-rr"
>or
> nls_date_format = dd-MON-rr ?

Documentation says it should be in double quotes. But in my experiences your second option (without any quotes) will behave the same as with double quotes.

>Thanks
>Suresh Bhat

HTH,, Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Feb 24 1999 - 18:14:20 CST