MySQL Forums
Forum List  »  MaxDB

Bug when using case+max+date
Posted by: Christian Aeberhard
Date: August 07, 2007 06:31AM

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

Options: ReplyQuote


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.