Hi Thomas, Thanks for your advice.
But, addGroupBy() accepts Field (name or FieldDescriptor). I want use group by like below, (with mysql) --- select DATE_FORMAT(DATE, " %Y %m %d"), count(*) from A0 group by DATE_FORMAT(DATE, " %Y %m %d") --- The type of DATE is TIMESTAMP. Is there any way ? On Thursday 05 June 2003 18:57, Mahler Thomas wrote: > Just have a a look at the Javadocs: > http://db.apache.org/ojb/api/org/apache/ojb/broker/query/QueryByCriteria.ht >m l#addOrderBy(java.lang.String) > > Thomas > -- -- shivaken antshell: Ant command line front end http://www.antshell.org --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]