Home >Java >javaTutorial >How to Store Date/Time and Timestamps in UTC with JPA and Hibernate?
Storing Date/Time and Timestamps in UTC with JPA and Hibernate
In Java Persistence API (JPA) and Hibernate, managing date/time and timestamp values across different time zones can be a challenge. To ensure consistent storage and retrieval of UTC (Coordinated Universal Time) time, it is crucial to configure the framework appropriately.
Consider the annotated JPA entity provided:
<code class="Java">public class Event { @Id public int id; @Temporal(TemporalType.TIMESTAMP) public java.util.Date date; }</code>
To store the date/time in UTC time zone, the hibernate.jdbc.time_zone property can be configured as follows:
Using Properties.xml
In the properties.xml JPA configuration file, add the following property:
<code class="XML"><property name="hibernate.jdbc.time_zone" value="UTC"/></code>
Using Spring Boot
If using Spring Boot, add this property to your application.properties file:
<code class="Properties">spring.jpa.properties.hibernate.jdbc.time_zone=UTC</code>
With this configuration, dates and timestamps will be stored and retrieved in UTC time zone. For example, if the date is 2008-02-03 9:30am Pacific Standard Time (PST), it will be stored as 2008-02-03 5:30pm UTC in the database. When retrieved, it will be interpreted as UTC time, so 5:30pm UTC remains 5:30pm UTC even after conversion to another time zone.
The above is the detailed content of How to Store Date/Time and Timestamps in UTC with JPA and Hibernate?. For more information, please follow other related articles on the PHP Chinese website!