Possible NLS_LANG bug?

From: Grant Allen <Grant_at_towersoft.com.au>
Date: Wed, 19 Jun 2002 19:03:24 -0800
Message-ID: <F001.00482379.20020619190324@fatcity.com>

Hi all,

I've been grappling with a really curly problem using the TO_DATE function, and came across this.

Try executing these two commands one your instance:

        select to_date('01/01/1970, 12:00 A.M.','MM/DD/YYYY HH:MI A.M.') from dual;

        select to_date('01/01/1970, 12:00 AM','MM/DD/YYYY HH:MI AM') from dual;

If you have an NLS_LANG setting under your home of AMERICAN_AMERICA.WE8MSWIN1252 (yes, this is from sqlplus on a windoze box), both with work. If the NLS_LANG is set to ENGLISH_AUSTRALIA.WE8MSWIN1252 , the first one will fail with an 01855 error. Needless to say, the TO_DATE doco suggests that either format is correct in all circumstances (makes no mention on NLS gotchas).

Before I open a TAR, can anyone suggest if I've missed anything obvious?

Platform is win2k, Oracle 9.0.1. Seems to be the oci layer itself that has the problem, not the instance - connecting to the instance on this box from sqlplus on another box behaves according to the remote box's setting.

Ciao
Fuzzy
:-)

---

"Woo Hoo!" - H. Simpson

---

The contents of this post are my opinions only

          If swallowed seek medical advice

(Apologies for the excess signature)

This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grant Allen
  INET: Grant_at_towersoft.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Wed Jun 19 2002 - 22:03:24 CDT