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

Home -> Community -> Usenet -> c.d.o.tools -> Changing default date format at instance level

Changing default date format at instance level

From: doug edmunds <dae_alt3_at_juno.com>
Date: 8 Sep 2000 12:04:00 PST
Message-ID: <8FA97D575DougEdmunds@199.2.117.165>

The Oracle manual says:
"You can alter the default value of NLS_DATE_FORMAT by changing its value in the initialization file and then restarting the instance, and you can alter the value during a session using an ALTER SESSION SET NLS_DATE_FORMAT command. "

Which initialization file are they referring to? How does the entry in the initialization file read for a default entry of 'YYYY-MM-DD'?

I put the alter session line into glogin.sql and it works, but it is lost on a 'connect different_user' in the same sqlplus session.

-- 
Doug Edmunds
Vancouver, Washington USA
edmunds::at::pacifier::dot::com
g
Received on Fri Sep 08 2000 - 15:04:00 CDT

Original text of this message

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