Re: How to change default DATE format

Francis Lo napisał(a) w wiadomości: <6kif8b$chj_at_news.Hawaii.Edu>...
>How do I change my Oracle default Date format to something like:
>DD-MON-YYYY HH24:MI:SS
>
>I try add the entry in my INITORCL.ORA file:
>
>NLS_DATE_FORMAT = DD_MON_YYYY_HH24_MI_SS
>

Hey!

Date format is a client paramete NO SERVER. You try adding
  NLS_DATE_FORMAT = DD_MON_YYYY_HH24_MI_SS in oracle.ini (if you use Win3.x)
or in register HKEY_LOCAL_MACHINE\software\oacle (Win95 or NT) If you use only SQL*Plus try set date format in login script (glogin.sql) Received on Thu May 28 1998 - 02:59:13 CDT