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