Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYSDate, NLS_DATE_FORMAT, and default values
You'll find that the nls_lang setting in your client will also set the date format for you. It's been a while since I had to look at it, but I think that the nls_lang setting in the client was overriding the nls_date_format I set for the database as a whole. I'm not sure if it would be affecting you, but it might be worth having a look at.
Brian Tkatch wrote:
> >
> >The trigger you created runs on startup of the database only. If you want to
> >go this route you need to do this for every connect, so on schema level.
> >
> >Hth,
> >
> >Sybrand Bakker, Oracle DBA
>
> Hey, thanx for replying!
>
> That works:
>
> ==========
> CREATE OR REPLACE TRIGGER Data_Logon_Trigger
> AFTER LOGON
> ON SCHEMA
> BEGIN
> EXECUTE IMMEDIATE
> 'ALTER SESSION SET NLS_DATE_FORMAT = ''DD-MON-YYYY
> HH24:MI:SS''';
> END;
> ==========
>
> A note, however. When I logon a second time in the SQL*Plus worksheet
> either via a command line, or via the connect dialog, it seems to
> reset NLS_DATE_FORMAT to just 'DD-MON-YYYY'.
>
> However, when I start a new SQL*Plus worksheet, all is well.
>
> Brian
Received on Mon Jun 19 2000 - 00:00:00 CDT