RE: NLS DATE

  • From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 24 Jun 2004 14:04:57 -0700

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Seema Singh
Sent: jeudi, 24. juin 2004 12:33
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: