Re: NLS_DATE_FORMAT not effective..help!

Yea, to see it on a clint's SQL*Plus You have to modify \Hkey_local_machine\software\oracle\NLS_DATE_FORMAT

At least this is on NT, I don't know about 95, 98

Gints Plivna

                                                                                       
                             
                    Arul kumar                                                         
                             
                    <rakumar_at_mahin        To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    drabt.com>            cc:                                          
                             
                    Sent by:              Subject:     NLS_DATE_FORMAT not 
effective..help!                         
                    root_at_fatcity.c                                                     
                             
                    om                                                                 
                             
                                                                                       
                             
                                                                                       
                             
                    01.03.20 10:36                                                     
                             
                    Please respond                                                     
                             
                    to ORACLE-L                                                        
                             
                                                                                       
                             
                                                                                       
                             

Hi Gurus,

We want to change the default date format of oracle from 'dd-mon-yy' to 'MM/DD/YYYY' format for one of our database ( 8.1.6 ).

I have set NLS_DATE_FORMAT as "MM/DD/YYYY" (also tried RRRR for year!) in init file. It doesn't seems to have any effect when i query sysdate
(SQL PLUS) from a client PC (Win 95 / Oracle 8 client / SQL PLUS) .
Still in SQL PLUS it is displaying the date as 20-MAR-01 ( default format - dd-mon-yy)

Ofcourse, after modifying, i bounced the db and listener.

Interesting thing is when i query sysdate from SQLPLUS of my server
(where Oracle is installed ), it is giving me the date as

SELECT SYSDATE FROM DUAL; 03/20/200 ( it should be 03/20/2001 )

What went wrong? Did anyone faced similar problem....? Do i need to modify registry in client PCs ( Win 9X)...??

Thank You.
Arul.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arul kumar
  INET: rakumar_at_mahindrabt.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: 
  INET: G.Plivna_at_itsystems.lv

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