to_date function and NLS settings on client

[Daiminger, Helmut]

Title: 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