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: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org