Spring jpa hibernate mysql LocalDate off one day after persist

Question

Whenever I persist LocalDate to MySQL Database, the Date is stored one day off (11 Nov 2017 becomes 10 Nov 2017). I've already tried to set the timezone in the application on MySQL server and set the legacyDateTimeCode to false but the problem still exists. Any idea on how to fix it? If I switch to local h2 Database, the Date is stored correctly.

Spring-boot-starter-parent: 1.5.7 hibernate 5.2.10 mysql: 5.7 LocalDate stored in DATE field

its off in db and in the application thats why i am curious. I thought it might be because of different timezone settings thats why i set them the same on mysql server and in the application. But even then its off. — Ceryni, Nov 10 '17 at 19:42
Hm... timezone of the actual machine (OS) on which it is running? I remember having this issue couple years back, unfortunately dont remember the details anymore. — Wabi, Nov 10 '17 at 20:48
Does [this answer](https://stackoverflow.com/a/40438746/2144390) help any? — Gord Thompson, Nov 11 '17 at 15:25
I'm having the same issue. Did you find a fix for it ? Thanks — db80, Apr 20 '18 at 08:26
i forgot about this. I had this issue again later in another project and it was due to the docker image i created having different time settings that the host. So make sure Host,docker images, and applications do have the same time settings — Ceryni, May 10 '18 at 16:19

score 1 · Answer 1 · answered May 16 '19 at 09:55

1

Add spring.jpa.properties.hibernate.jdbc.time_zone : UTC In Properties file

answered May 16 '19 at 09:55

Naveen

29
4

Spring jpa hibernate mysql LocalDate off one day after persist

1 Answers1