Re: Setting date format in Oracle 8i

Marco,

The NLS_DATE_FORMAT can also be set the on the client which overrides the server settings. If you are using NT then NLS_DATE_FORMAT is set at a registry level under HKEY_LOCAL_MACHINE => SOFTWARE =>ORACLE. If using UNIX it can be set as one of the environmental variables for your shell. Also if your client has NLS_LANG set to something different on the client from the in the init.ora this will take precedence and can influence what date format is displayed.

Kind Regards

Fraser McCallum
MVP Oracle
www.brainbench.com

"Marco Mapelli" <mapellim_at_usa.net> wrote in message news:53d76e1f.0110070850.7b52c150_at_posting.google.com...
> Hello Tom,
>
> I just changed my init.ora file to specify
> a desidere date format thru the parameter
>
> NLS_DATE_FORMAT = DD-MM-YYYY
>
> but after restarting my instance and connecting
> to sqlplus and selecting from a DATE field I still
> see the default date format DD-MON-YY without
> altering any session.
> Should the initialization parameter set the date format
> for all sessions ?
>
> Thanks and regards
>
> Marco
>
Received on Sun Oct 07 2001 - 17:19:38 CDT