What timezone are your timestamps recorded in in the MySQL DB?
If UTC then you can add some parameters to the jdbc connection string.
jdbc:mysql://localhost/mydb?useTimezone=true&useLegacyDatetimeCode=false&serverTimezone=UTC
2 Likes