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_parameters and if the session has explicitly set it, the new value
wil
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 recipie
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-YYY
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 num