JPA+Hibernate date displays wrong data

Question

I user hibernate+spring+mysql 5.7. When I save date 20/04/1939, it stores correctly in database.

@Column(name = "birth_date")
    @Temporal(TemporalType.DATE)
    private Date birthDate;

the value stored in database after save is 1939-04-20.

when i display it using

person.getBirthDate()

it displays 19/04/1939. It is not related with my formatting. The value it retrieves from db is one day less.

It is always showing 1 day less when i use year 1939 with any date. So what's wrong here? Also for other years, dates are showing perfectly.

Looks like a time zone issue. What database are you using? What time zone is your computer using? — Andreas, Dec 17 '19 at 05:50
i m using mySql 5.5 as database and my timeZone is Bangladesh Dhaka — TanvirChowdhury, Dec 17 '19 at 05:53
Possible duplicate of [JPA TemporalType.Date giving wrong date](https://stackoverflow.com/q/5300047/5221149) — Andreas, Dec 17 '19 at 06:06
Sorry your link does not help me anyway.Please see the edited question. — TanvirChowdhury, Dec 17 '19 at 09:04

score 0 · Answer 1 · answered Jan 14 '20 at 06:35

0

updating the database timezone solved this issue.

answered Jan 14 '20 at 06:35

TanvirChowdhury

can you describe what exactly you did to solve the problem please, I have the same problem. – tchiko Jan 12 '23 at 11:05

1 Answers1