Re: Specifying NLS_DATE_FORMAT

check out Thomas Kytes web site for reasons why this might be so

http://govt.us.oracle.com/~tkyte/Misc/NLSDateFormat.html

cheers

NeilC

Ed Stevens wrote in message <7vmvqj$1qq$1_at_nnrp1.deja.com>...
>I have a question about the use of the NLS_DATE_FORMAT parm. If I
>don’t have it set anywhere, then I see this:
>
>SQL> select sysdate from dual;
>
>SYSDATE
>---------
>02/NOV/99
>
>If I put this in my INIT<sid>.ORA file:
>
>nls_date_format = 'MM-DD-YYYY HH24:MI:SS'
>
>I see no difference in my SELECT statement.
>
>If I put the above format parm into my registry at
>HKLM\SOFTWARE\ORACLE, I still see no difference in my SELECT
>statement. The only way I seem to get the specified format is to do an
>ALTER SESSION. My understanding was the format for presentation and
>acceptance of DATE datatypes was controlled by NLS_DATE_FORMAT in
>INIT<sid>.ORA, unless overridden by environment variable/registry key,
>unless overridden by ALTER SESSION. Do I misunderstand, or am I
>missing something that is supposed to be obvious?
>
>- Ed Stevens
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Nov 02 1999 - 09:46:35 CST