Setting nls_date_format in initSID.ora
| From: | simon dot pospisil at fastsearch dot com | Date: | Fri, 31 Aug 2001 13:56:05 +0000 |
| Subject: | Setting nls_date_format in initSID.ora | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12029@lists.php.net to get a copy of this message | ||
Hello, I've tried changing the nls_date_format variable from:
nls_date_format = DD-MON-YYYY
to
nls_date_format = YYYY-MM-DD
Then I restart the database but it will only use the old format, the new
format has not been recognised. I'm editing the initSID.ora file where
SID is the sid of the database in question. Is that right? However, if
I alter the format within a session then it works fine.
Any ideas?
Cheers
Simon.