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

Hi Fernand,
It feels to me as I touched in some days ago, and find it, as a known 
issue with cast in MySQL: 
http://qa.openoffice.org/issues/show_bug.cgi?id=115436
Zoltan

2010.12.08. 13:12 keltezéssel, Fernand Vanrie írta:
> 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]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>