Setting initXXXX.ora nls_date_format

From: Oracleguru, Suresh Bhat <oracleguru_at_mailcity.com>
Date: Wed, 24 Feb 1999 16:21:49 GMT
Message-ID: <01be6021$f6999480$a504fa80@mndnet>

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:

SQL> select tag_date from table1;

TAG_DATE

---

'23-FEB-99'
'23-FEB-99'
Apparently, it is not the same as setting it in SQL*Plus.

What is the correct way of setting the nls_date_format ?

Is it

  nls_date_format = "dd-MON-rr"
or
  nls_date_format = dd-MON-rr ?

Thanks

Suresh Bhat Received on Wed Feb 24 1999 - 10:21:49 CST