Bug when using case+max(date) together
Hello!
I think there is a bug in MAXDB 7.5.00.44.
datneu is from the datatype date
When i execute a statement like:
Select max(datneu) from tabelle
i get a correct date-format like '2007-07-31'.
But when i execute a statement like:
Select case when max(datneu)='1900-01-01' then '2000-01-01' else max(datneu) end datneu from tabelle
i get a wrong date-format like '20070731'.
This caused me some trouble and i don't think that it is a normal behaviour... ;-)
Kind regards
Christian
Subject
Written By
Posted
Bug when using case+max(date) together
August 07, 2007 06:39AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.