Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to change default DATE format
You can change the default date format on the server by setting the
init.ora parameter nls_date_format = "DD-MON-RR" etc...
Note the double quotes which are required under UNIX (at least on our
platform).
Their absence may or may not be the solution to the problem the original
post was about.
Paweł Plichta <Pawel_Plichta_at_netia.pl> wrote in article
<6kj5h2$e31$1_at_info.nask.pl>...
>
> 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 - 10:08:05 CDT