Hello Norbert, > > I have to set up a query in OO-base like this one. In "mysql dialect" it > would be > > SELECT DATE(`datetime-field`) AS `workdate`, SUM(`field-2`), > SUM(`field-3`), .... FROM `Another-Query` > WHERE .... > GROUP BY `workdate` > ORDER BY `workdate` DESC
In hsqldb there is no function called DATE. http://hsqldb.org/doc/guide/ch09.html You can try DAYOFMONTH(`datetime-field`)||'.'||MONTH(`datetime-field`)||'.'||YEAR(`datetime-field`) AS `workdate` for a german dateformat like 4.3.2011. Robert -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
