LocalDate changing dateb when being saved to a mySQL database

Asked Aug 10 '20 at 18:53

Active Aug 10 '20 at 18:53

Viewed 156 times

when i save a LocalDate field with the current date using spring boot to a mySQL Date column that way

LocalDate.now()

it saved with day-1 for example today is 10-08-2020 but in the database i found 09-08-2020 However, when i display the current date it return the correct date

asked Aug 10 '20 at 18:53

user13031827

check the timezone of the server – nbk Aug 10 '20 at 19:36
spring.datasource.url=jdbc:mysql://localhost:3306/pfedatabase?serverTimezone=UTC But how to change it in the application.properties in order to return the correct current day – user13031827 Aug 10 '20 at 20:51
see https://stackoverflow.com/a/37185444/5193536 – nbk Aug 10 '20 at 21:08

LocalDate changing dateb when being saved to a mySQL database

0 Answers0