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