Re: NLS_DATE_FORMAT and Y2K

From: Gene Hubert <ghubert_at_netpath.net>
Date: Fri, 17 Sep 1999 03:01:33 GMT
Message-ID: <84A3805B74D27B2D.F6F1B7CDE4EBEEC5.D75FD0A88E730215@lp.airnews.net>

I'm a-frayed I don't get it and will take a chance on looking foolish by asking: Why should NLS_DATE_FORMAT have anything to do with the result of this query. You're giving a date as text and saying exactly how the text should be interpretted to convert it to a date. What am I missing?

Does
SELECT TO_DATE( '29-FEB-2000', 'DD-MON-YYYY' ) ) ) FROM DUAL;
product the same result?

Gene Hubert
SkillsPoint.com

On Thu, 16 Sep 1999 11:35:20 GMT, Rich Goldkamp <RJGoldka_at_dcss.com> wrote:

>Can the NLS_DATE_FORMAT parameter be set at the instance level???
>
>When I execute the following query, it returns an error when run
>against an instance where the NLS_DATE_FORMAT parameter has been set.
>
>SELECT TO_DATE( DECODE( dummy, 'N', 'X',
> TO_DATE( '29-FEB-2000', 'DD-MON-YYYY' ) ) )
>FROM DUAL;
>
>ERROR at line 1:
>ORA-01839: date not valid for month specified
>
Received on Thu Sep 16 1999 - 22:01:33 CDT