SQLize | PHPize | SQLtest

select version(), @@time_zone; set @@time_zone = '-05:00'; select version(), @@time_zone; CREATE TABLE aa ( id int NOT NULL AUTO_INCREMENT, epochmillis bigint, fut DATETIME(3) generated always as (from_unixtime(epochmillis/1000)), utc DATETIME(3) generated always as ('1970-01-01' + interval epochmillis*1000 microsecond), PRIMARY KEY (`id`)); insert into aa (epochmillis) values (0),(2200111222333), (55000111222333), (29000111222333), (1000*unix_timestamp(now(3))); select aa.*, unix_timestamp(fut), unix_timestamp(utc), @@time_zone, utc_timestamp(6) as 'now' from aa; set @@time_zone = 'SYSTEM'; select aa.*, unix_timestamp(fut), unix_timestamp(utc), @@time_zone, utc_timestamp(6) as 'now' from aa; select aa.* from aa where year(utc) > 2038