Re: CAST() no longer working as SQL function

Moin,

On 09.12.2010 09:18, Ocke Janssen wrote:
> 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.
Thanks to Alex who pointed me to the statement to use.
I reopened the issue. Please have a look at it for the reason.

Thanks.

Ocke

>
> A workaround could be to use the convert function which should be equal
> as the MySQL doc states.
>
> Best regards,
>
> Ocke
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>