Re: Question on NLS_DATE_FORMAT

Goto the Thomas Kyte Web site.
He has a database trigger that works
at logon time, so it is in effect for everone.

>I can do an alter session, set nls_date_format = 'DD-MON-YYYY' and ok.
>But I want this to be consistent for every session, stored proc,
>package, etc.
>
>I have gone into my init.ora and set the nls_date_format and restarted
>the instance. I can even use svrmgrl and do a show parameters NLS and
>see that the format is correct.
>
>Why would the date still be returning in 00 format vs 2000?
>
>Thanks,
>Sean
>
>
Received on Sat Apr 08 2000 - 00:00:00 CDT