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

Reizinger Zoltán <[email protected]> Wed, 08 Dec 2010 12:07:44 +0100
Newsgroups gmane.comp.openoffice.dba.devel
Message-ID <[email protected]>
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
>