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

Binary/unsupported file stripped by Ecartis --
Type: text/x-vcard
File: Lex de Haan.vcf

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Thu Jun 24 2004 - 14:54:31 CDT