RE: NLS DATE
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Jun 2004 21:57:37 +0200
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Seema Singh
Sent: Thursday, June 24, 2004 20:33
To: oracle-l@xxxxxxxxxxxxx
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@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
-----------------------------------------------------------------
-- 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
----------------------------------------------------------------
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:
