4 MINDS

4MINDS Gestão de Conhecimento

mysql timezone transition sql update


*********************************
* não lembro onde nem quando usei isso, nem se funcionou, vou salvar, vai saber
*********************************

SELECT * FROM mysql.time_zone_name;

2018-11-04 03:00:00 = 1541289600
2018-10-21 03:00:24 = 1540090824

select * from mysql.time_zone_transition where Time_zone_id = 1325 and Transition_time between 1167634800 and 1199170799;
select * from mysql.time_zone_transition where Time_zone_id = 1325 and Transition_time between 1538352000 and 1543622400 order by Time_zone_id,Transition_time;
update mysql.time_zone_transition set Transition_time = 1541289600 where Time_zone_id = 1325 and Transition_time = 1540090824;

right/America/Sao_Paulo                1325