Hibernate version:2.1

database:informix

Hi,

We are trying to compare 2 dates where one has a timezone GMT+1 and the other (the one selected from the database) seems to have no timezone. even when the date is the same it is obvious that the comparison is false due to the timezone.

we map date properties in de mapping files as of type=date and in the informix datebase the field is of type DATETIME. does anyone have a limited work solution for this problem. writing our own dateComporator would involve a lot of refactoring we are wondering if it is possible to have the hibernate date having set the same timezone and how to do this.

Maybe a UserType helps. If you somehow know the correct time zone in the nullSafeGet method you could add it and return whatever date type you'd like to have.

HTH
Ernst