RE: NLS DATE

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 24 Jun 2004 14:04:57 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87932@irvmbxw02>

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

Received on Thu Jun 24 2004 - 16:01:56 CDT