Bug when using case+max+date
Hello!
I think there is a bug in MAXDB 7.5.00.44.
When i execute this statement:
Select max(datneu) from tabelle
i get a normal date-format like '2007-07-31' as result.
But when i execute something 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' as result.
I think that is not a normal behaviour and it caused me some troubles... ;-)
Kind regards
Christian
Subject
Written By
Posted
Bug when using case+max+date
August 07, 2007 06:31AM
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.