What is the version of the MySQL JDBC Driver?.

What is the local time zone of the JVM?.

How did you 'reveal' the problem? With a SQL client or from Java?.

The UTC_TIMESTAMP() function always returns the current UTC date and time. If I create a mysql trigger to update/set date using 'UTC_TIMESTAMP()', the date is displayed in the 'UTC' time. Whether you're using DATETIME or TIMESTAMP, the answer is no.Īnother observation I made is, the above date 'conversion' issue exists only when Im setting the date in the Java application. I've updated my initial answer (which was not totally accurate/exhaustive). So now my question becomes, is timezone info also stored in mysql? That means mysql converts the 'milliseconds since epoch' to the above format. MySQL documentation for DateTime says 'MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format'.

Bug #15604: TimeZone discarded storing into DATETIME.

Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J

Does the 'problem' occur in your SQL client? In Java code? References This begs the question: how did you actually check the value of the 'persisted date'.

However, it looks like a different conversion is done when displaying them. In both cases, my point is that storing ' 00:08:08' - GMT or ' 08:08:08' - eastern time US from Java should yield to the same value in the database. (.)Īnd second, unless a buggy behavior, my understanding is that the conversion is supposed be done either by the server or by the JDBC driver depending on the the server time zone settings so that you don't get inconsistent data. (.)ĭATETIME is an 8-byte string of digits 'yyyymmddhhmmss'. That is, the TZ offset is applied as you store a value, then reapplied when you fetch it. TIMESTAMP is seconds since 1970, sitting in 4 bytes. Ok, first, whatever column type are you using to store your date in MySQL (TIMESTAMP or DATETIME), neither stores the time zone. the value has been set in the entity setter as ' 00:08:08' - GMT the actual value persisted to the database is ' 08:08:08' - eastern time US. Here is the way to use it in the Person class.However, when hibernate actually persists to the database, the date is converted to local time and stored) ex.

class ) ( defaultRollback = false ) public class HibernateDateTimeTest assertTrue import import import import import import .time.DateUtils import import import import import import import .ContextConfiguration import .junit4.SpringJUnit4ClassRunner import .transaction.TransactionConfiguration import .Transactional import ( SpringJUnit4ClassRunner.

Hibernate date format