2006/11/6, Elke Schmidtke <[EMAIL PROTECTED]>:
Hi,the following select select decode (date, null, '2099-12-31', date) from dual returns 20061106 Why not a date?
My guess would be that MaxDB coerces the return value of decode into the most general one. Try to convert your argument '2099-12-31' to a date and see what happens. Kind regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
