Hello all, it´s my first post.
I´m having problems with an HQL. I use PostgreSQL 8.1, and I need to make a select that returns every Timestamp field that has an hour, let´s say, afte 7:00. Tryed using to_date, but it doesn´t seem to work this way:

to_date('07:00','HH:mi')

anyone got any idea?

I want to verify the time of every date on a Timestamp field.

Thanks!

have you tried
?

I've never used those time expressions, I'm just going off of what's in the docs:

http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#queryhql-expressions

ERROR: function hour(timestamp without time zone) does not exist