Re: Date format

You have put NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS" even in your environment (i.e. where you define ORACLE_SID) to have it work correctly.

Mike Ng ha scritto nel messaggio <38ed868f_1_at_news1.prserv.net>...
>Hi all,
>
>I want to use the date format like this "DD-MM-YYYY HH24:MI:SS" but I need
>use the sql
>"alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS" to setup the
>environment every time I login.
>
>I have try to add the following format in init.ora file but it did not
 work.
>The string I add is NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS" Is there
>elsewhere I need to change? Please give me some hints.
>
>Thanks a lot.
>
>Regards,
>Mike Ng
>
>
Received on Fri Apr 07 2000 - 00:00:00 CDT