RE: NLS DATE

From: <J.Velikanovs_at_alise.lv>
Date: Sun, 27 Jun 2004 00:33:39 +0300
Message-ID: <OF7E9952F9.D242E540-ONC2256EBF.00739B99-C2256EBF.00771A17@alise.lv>

CREATE OR REPLACE TRIGGER logon_vjv
AFTER
LOGON
ON DATABASE
begin
execute immediate 'alter session set NLS_DATE_FORMAT=''YYYY/MM/DD'''; end;
/
or any format you want.

Jurijs

"Jacques Kilchoer" <Jacques.Kilchoer_at_quest.com> Sent by: oracle-l-bounce_at_freelists.org
25.06.2004 00:04
Please respond to oracle-l

        To:     <oracle-l_at_freelists.org>
        cc: 
        Subject:        RE: NLS DATE

When you say "I want whole table data should be like..." You do realize that the DATA inside the Oracle table is the same regardless of your NLS_DATE_FORMAT?
If you want this display only in SQL*Plus, you can change the glogin.sql file to have an ALTER SESSION SET NLS_DATE_FORMAT...=20 If you want this display only in this particular SQL statement, you can use TO_CHAR to format the date whichever way you want. If you want this display for every client application from a particular machine, you would have to set NLS_DATE_FORMAT on the client in an environment variable.
You can set these values at the instance level, but it will be overridden by the settings on any client machine.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Seema Singh Sent: jeudi, 24. juin 2004 12:33
To: oracle-l_at_freelists.org
Subject: NLS DATE=20

Hi,
How to fix NLS_DATE_FORMAT problem without altering the session? Like

NO TDATE
---------- ---------

        10 24-JUN-04
        20 24-JUN-04

I want like

NO TDATE
---------- ----------

        10 2004-06-24
        20 2004-06-24

Is any parameter which need to setup at init.ora file? I tried yyyy-mm-dd=20
but didn't helped? I want whole table data should be like "yyyy-mm-dd'. pLEASE suggest if any?
thx

FREE pop-up blocking with the new MSN Toolbar - get it now!=20 http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------





----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------






----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Sat Jun 26 2004 - 16:37:57 CDT