NLS DATE

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Thu, 24 Jun 2004 15:33:23 -0400
Message-ID: <BAY19-F32G5wQ0l8HvN000134e9@hotmail.com>

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

---

Received on Thu Jun 24 2004 - 14:30:14 CDT