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.
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.