Re: NLS_DATE_FORMAT

On Tue, 8 Feb 2000 09:58:49 +0100, "jst" <jsp_at_pobox.sk> wrote:

>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
>
>
>
>

What do you mean by 'restart'?

Did you store sysdate in a column of type date? Only for this type the the value will be shown in the format you specified.

Jaap. Received on Tue Feb 08 2000 - 18:21:31 CST