DROP TABLE IF EXISTS t1; show variables like "timezone"; Variable_name Value timezone MET select @a:=FROM_UNIXTIME(1); @a:=FROM_UNIXTIME(1) 1970-01-01 01:00:01 select unix_timestamp(@a); unix_timestamp(@a) 1 CREATE TABLE t1 (ts int); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 01:00')); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00')); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 03:00')); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00')); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 01:00')); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00')); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 02:59:59')); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 03:00:00')); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 03:59:59')); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 04:00:01')); SELECT ts,from_unixtime(ts) FROM t1; ts from_unixtime(ts) 1035673200 2002-10-27 01:00:00 1035680400 2002-10-27 02:00:00 1035684000 2002-10-27 03:00:00 1035680400 2002-10-27 02:00:00 1035673200 2002-10-27 01:00:00 1035680400 2002-10-27 02:00:00 1048986000 2003-03-30 03:00:00 1048986000 2003-03-30 03:00:00 1048989599 2003-03-30 03:59:59 1048989601 2003-03-30 04:00:01 DROP TABLE t1;