Re: CAST() no longer working as SQL function

Moin,

On 08.12.2010 11:54, Fernand Vanrie wrote:
> I use for years in SQL queries : CAST("OOtimestamp" as date)
>
> This block queries in OOO 330m16
>
> is this a showstopper for 3.3.0 ?
>
> Fernand
>

This seems to be a db or driver problem which we can't fix. I tried 
StarOffice 9.2 equal OOo 3.2 and 3.2.1 and 3.3 even DEV300m94 and all 
reports the same error. Then I tested the select with ODBCTEST from MS 
and the error still occur. The silly thing is that the MySQL workbench 
works. I don't know what they are using.

A workaround could be to use the convert function which should be equal 
as the MySQL doc states.

Best regards,

Ocke