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@mahin To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
drabt.com> cc:
Sent by: Subject: NLS_DATE_FORMAT not
effective..help!
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).