CODE EXAMPLE FOR SQL

intellij mysql set timezone

value="jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC"


in MYSQL do :(for french people, change the zone for u) 

SET GLOBAL time_zone = 'Europe/Paris';
SET time_zone = 'Europe/Paris';


+ see spring configuration : 
https://www.baeldung.com/mysql-jdbc-timezone-spring-boot