Re: to_date function and NLS settings on client

Wed, 20 Nov 2002 07:02:17 -0800

Title: to_date function and NLS settings on client
Helmut,
 
your format is wrong, it should be:
 
to_date('01.10.1950','DD.MM.YYYY')
 
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
 
 
 
----- Original Message -----
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

Reply via email to