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