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-');
Some clients return the correct number of rows where
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.')
instead of:
to_date('01.10.1950','DD-MM-');
or the
other way around!
/Johan
Title: to_date function and NLS settings on client
Helmut,
your format is wrong, it should be:
to_date('01.10.1950','DD.MM.')
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Daiminger, Helmut
To: Multiple recipients of list ORACLE-L
Sent
Title: to_date function and NLS settings on client
Helmut,
The cleint nls_date setting can be done by
ALTER SESSION SET NLS_DATE_FORMAT =
'dd.mm.';
The currect setting can be seen from
v$nls_parametersand if the session has explicitly set it, the new value
will be shown.
However, I
