I have a field of type 'datetime' in a MySQL (5.0) table but when I persist any date/time information, the time is off by one hour in the database but when I print out the information about the object that was persisted, it shows the correct date/time until I re-load it from the database. Is there someplace in the mapping file I need to specify a TimeZone converter or setting? It almost seems like it's a DST shift..

My table is mapped as:
<class name="Event" table="EVENTS">
...
<property name="date" type="timestamp" column="STARTDATETIME"/>.
</class>

When I create a new Event object, I call 'setStartDateTime' with a Timestamp value and the value is correct. I persist the newly created object and then when I look into the database, the time is always one hour behind..


Thanks,
Justin

I have noticed that on MySQL, when a timestamp column's default value is 'current date' (or something like that), the column value gets updated to now() each time the row is updated.
Is there any chance that you're using a remote database and the server time isn't correct ?

I have the default value of the field in the database as "0000-00-00 00:00:00" and the newly created times aren't equal to "now". And regardless of what time I specify, the database gets the value as 1 hour behind the specified time.

Thanks,
Justin