Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: NLS DATE

RE: NLS DATE

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Thu, 24 Jun 2004 21:57:37 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNEEAGCFAA.lex.de.haan@naturaljoin.nl>


Hi Seema,
this is not too easy -- check out the Oracle Globalization Support Guide for details and examples.
you can set NLS_DATE_FORMAT="yyyy-mm-dd" at the instance level, but the NLS_LANG (client side) parameter setting plays a role here too -- which is the reason why you typically want to change this at the session or statement level,
and not at the instance level...

Kind regards,
Lex.



visit my website at http://www.naturaljoin.nl

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

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

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

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:54:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US