RE: Confusing update issue!

From: Michael Thomas <mhthomas_at_yahoo.com>
Date: Mon, 6 Sep 2004 07:17:41 -0700 (PDT)
Message-ID: <20040906141741.62586.qmail@web50609.mail.yahoo.com>

Hi,

In your original message if you wish to figure out what happened with NLS date paramenters, please try setting: nls_date_format

You can confirm these parameters in the OS environment, and in SQL*Plus with some simple tests.

Below you typed?
nvl_date_format

2) The session NLS setting should work for dates if its set. But, since NLS...(whatever) can be set in the multiple places, with different precedence, and at different places for applications on different OS's, its a risk for errors. Also, different settings for NLS_DATE can alter default NLS_LANG character conversions in an USASCII7 database environment (you probably already know all this...).

I think its better to convert to a date like Lex suggests. :-)

HTH Regards,

Mike Thomas

Lex de Haan <lex.de.haan_at_naturaljoin.nl> wrote:
> Denham,
>
> I think the best cure is to solve the root problem
> -- that is, the script
> itself.
....
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
> Denham Eva
...
> I have tried alter session and setting
> nvl_date_format = 'DD-MON-YYYY'.
> Same thing.
... Oops. nvl?

> Run this script in different front ends including
> toad. Same thing.

...

Toad may be reading nls_date from the registry or the OS environment, if its set. Java adds another layer of complexity if its involved (But, I don't think Toad uses java). If nls_date is not set, then there are a bunch of rules to determine what effective nls_date is used by your session and database. Sometimes its hard to figure out.

Good luck.

Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/

Received on Mon Sep 06 2004 - 09:13:10 CDT