I want to use raw HQL to query objects based on a data field. So I want to do the equivalent of

"from Event as e where e.data='Jan 20, 2004'"

However, that doesn't work. I assume that my date string isn't properly formatted. I've looked through the forums for HQL example outlining that but couldn't find one. Could someone please give me a simple-minded example that shows the proper date format needed when issuing HQL queries.

Thanks, in advance for any help
Adam

I'm interesting in the format where the underlying Java type is java.util.Date. Sorry for confusion.

Why dont you use named parameters, where date format would be taken care of.

If you want to code it into the query then you'll need to use whatever format your database accepts, just like with real SQL, eg with SQL Server:



or you could use the database date functions.

Or, much better than both of those options, use params - eg:



This means that Hibernate can parameterise the stored procedures so that the same compiled query is used for multiple dates and you don't need to worry about locale or parsing issues.