Re: Setting date format in Oracle 8i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 7 Oct 2001 22:18:45 +0200
Message-ID: <ts1kk3t88vkc80@news.demon.nl>

"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

No,
you should set it on the clients as well on Unix : by using the env var NLS_DATE_FORMAT on Windoze: by creating a string value NLS_DATE_FORMAT in hkey\local_machine\software\oracle

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sun Oct 07 2001 - 15:18:45 CDT