SV: to_date function and NLS settings on client

[Johan Malmberg]

Title: to_date function and NLS settings on client

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

Maybe because the mask is wrong... ;)

try:

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

instead of:

 to_date('01.10.1950','DD-MM-YYYY');

or the other way around!

/Johan

 

-----Ursprungligt meddelande-----
Från: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]För Daiminger, Helmut
Skickat: den 20 november 2002 14:04
Till: Multiple recipients of list ORACLE-L
Ämne: 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