Oracle-L: Re: to_date function and NLS settings on client

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Wed, 20 Nov 2002 06:33:40 -0800
Message-ID: <F001.00507D12.20021120063340@fatcity.com>

to_date function and NLS settings on clientHelmut,

your format is wrong, it should be:

to_date('01.10.1950','DD.MM.YYYY')

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

Original Message ----- From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 20, 2002 8:03 AM Subject: to_date function and NLS settings on client

Hello!

We have several Windows clients connecting to our db-server. Every client issues the statement:

select .... from thabe where date = to_date('01.10.1950','DD-MM-YYYY');

Some clients return the correct number of rows where as others return nothing.

I know that this has something to to with the NLS settings on the client.

How do I find out the NLS settings on the client? Just in the registry?

How coem this does not work although I explicity specify a format mask?

This is 8.1.7 on Solaris.

Thanks,
Helmut

--

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

Author: Igor Neyman
INET: ineyman_at_perceptron.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Nov 20 2002 - 08:33:40 CST