Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: NLS_DATE_FORMAT
To set it at the session level, You need,
Alter session set nls_date_format='DD-MON-YYYY HH24:MI';
You can give any valid format string.
If you want this to happen automatically in your sqlplus session you can add
this to your glogin.sql script.
Hope this helps.
Viral.
>From: "Farnsworth, Dave" <DFarnsworth_at_Ashleyfurniture.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: NLS_DATE_FORMAT
>Date: Mon, 09 Sep 2002 11:48:24 -0800
>
>Set it in the <SID>init.ora.
>
>Dave
>
>-----Original Message-----
>Sent: Monday, September 09, 2002 2:18 PM
>To: Multiple recipients of list ORACLE-L
>
>
>On NT/2000, how can you set the NLS date format at the session level?
>Isn't
>there a file that you can set it in? What do you write in the file?
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Eric Richmon
> INET: cemail2_at_sprintmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).