Re: NLS_DATE_FORMAT

Either change or add nls_date_format in the registry of the client in hklm\software\oracle (for all products) or include an alter session statement in your login.sql (for sqlplus only). Alter session is just what it says: it alters your session. You shouldn' t restart your session.

Hth,

Sybrand Bakker, Oracle DBA

jst <jsp_at_pobox.sk> wrote in message
news:950000332.718461_at_virtual.nextra.sk...
> How can I change NLS_DATE_FORMAT from "DD-mmm-YY" to e.g. "DD.MM.YYYY"? I
> want to insert SYSDATE into a table and see through the SELECT command in
> other format than default. I tried to set NLS_DATE_FORMAT = "DD.MM.YYYY"
in
> init.ora file, or ALTER SESSION SET NLS_DATE_FORMAT = "DD.MM.YYYY" and
> restart, but it does`nt work. I`m using Oracle 8.0.5 on Win NT.
>
> Thanks, Jan
>
>
>
>
Received on Tue Feb 08 2000 - 03:36:25 CST