Hi,

I have a problem when i try to compare a java.util.Date with a persisted java.util.Date in a postgres database using HQL. Basically when the util.date is stored in the DB it is stored as a timestamp with a timezone. When i compare a date created by a user in my java app with the persisted date in the database i'm am not getting correct results. I think it is because of the timezone offset.

When i change the database date to a timestamp without a timezone my comparisons worked fine.

At the moment my date is mapped as a util.Date. How can i map it so that Hibernate knows not to interpret timezones. I.e. as a timestamp without a timezone.

Any help would be great!

Scott.

I'm always storing the date as Date.getTime() value - it' s comparable, and not affected by timezones...

regards,