Re: nls_date_format in initSID.ora

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 31 Aug 2001 18:08:34 -0700
Message-ID: <9mpcei01s08@drn.newsguy.com>

In article <3B8F9815.5D29074A_at_fastsearch.com>, simon.pospisil_at_fastsearch.com says...
>
>
>--------------828954952C993CA49E87D6D5
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>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?
>

see
http://osi.oracle.com/~tkyte/Misc/NLSDateFormat.html

>Cheers
>
>Simon.
>
>
>
>--
>
>Simon Pospisil Mail: simon.pospisil_at_fastsearch.com
>Web Programmer Web: http://www.fastsearch.com/
>Fast Web Media Ltd. Phone: +44 (0) 161 835 3444
>Suite 1202, Sunlight House Quay Street Fax: +44 (0) 161 835 3488
>Manchester, England M3 3JZ
>
>Try FAST Search: http://www.alltheweb.com
>Try: www.megasoccer.com
>Try: www.fa-premier.com
>
>
>
>--------------828954952C993CA49E87D6D5
>Content-Type: text/html; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
><!doctype html public "-//w3c//dtd html 4.0 transitional//en">
><html>
>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.
>  
>  
><pre>-- 
>
>
>Simon
>Pospisil                         
>Mail:  simon.pospisil_at_fastsearch.com
>Web
>Programmer                         
>Web:   <A
>HREF="http://www.fastsearch.com/">http://www.fastsearch.com/</A>
>Fast Web Media
>Ltd.                    
>Phone: +44 (0) 161 835 3444
>Suite 1202, Sunlight House Quay Street  Fax:   +44 (0) 161 835
>3488
>Manchester, England M3 3JZ
>
>Try FAST Search: <A HREF="http://www.alltheweb.com">http://www.alltheweb.com</A>
>Try: www.megasoccer.com
>Try: www.fa-premier.com</pre>
> </html>
>
>--------------828954952C993CA49E87D6D5--
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Fri Aug 31 2001 - 20:08:34 CDT