Re: CAST() no longer working with OOO 330m16

hi Zoltán ,

Indeed with the built-in hsqldb CAST still works, but no longer with a 
connection (using the native connector) to mySQL !
same situation for OOO 330m16 and m17

Fernand
> Hi Fernand,
> The CAST("timestampvalue" as date) working for me in windows version 
> of OOo 3.3RC7(m17), with SQL direct, with built-in hsqldb.
> Regards,
> Zoltan
>
> 2010.12.08. 11:45 keltezéssel, Fernand Vanrie írta:
>> Just found that queries who worked for years are halted now (OOO 
>> 330m16) using Cast("timestampvalue" as date)
>> CAST("timestampvalue" as date) use to run in direct SQL mode
>> I think that CAST as date is no longer "loved" and by mySQL they 
>> recommand DATE("timestampvalue")  i have some queries around with 
>> CAST , do not know if there are more ? andis it whort a issue ?
>>
>> Greetz
>>
>> Fernand
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]