Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> NLS_DATE_FORMAT

NLS_DATE_FORMAT

From: jst <jsp_at_pobox.sk>
Date: Tue, 8 Feb 2000 09:58:49 +0100
Message-ID: <950000332.718461@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 - 02:58:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US