[jboss-user] [EJB 3.0] - EJB-QL Convert timestamp to date

Hi, I have a enitity with a timestamp field, but would like to query it with a date value. Is there a portable way to truncate a timestamp to a date within an ejb-ql query? E.g. something that would be functionally equivalent to the following Postgres query. SELECT * FROM foo WHERE date_trunc('day', foo.timestamp) = date '2007-03-01' Regards, Michael Barker. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4016073#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...