Related Documentation Download this Manual
PDF (US Ltr) - 39.5Mb
PDF (A4) - 39.5Mb
PDF (RPM) - 38.7Mb
HTML Download (TGZ) - 11.0Mb
HTML Download (Zip) - 11.0Mb
HTML Download (RPM) - 9.7Mb
Man Pages (TGZ) - 217.1Kb
Man Pages (Zip) - 326.8Kb
Info (Gzip) - 3.6Mb
Info (Zip) - 3.6Mb
Excerpts from this Manual

time-zone-leap-seconds

This page has moved or been replaced. The new page is located here:

https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html

Please update any bookmarks that point to the old page.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
  Posted by Ben Clewett on June 29, 2015
This seems not to be the case on 5.6.24:

CREATE TABLE t1 (a INT, ts TIMESTAMP DEFAULT NOW(), PRIMARY KEY (ts) );
SET time_zone = '+00:00';
SET timestamp = 1230767999;
INSERT INTO t1 (a) VALUES (1);
SET timestamp = 1230768000;
INSERT INTO t1 (a) VALUES (2);
SELECT a, ts, UNIX_TIMESTAMP(ts) FROM t1;

+------+---------------------+--------------------+
| a | ts | UNIX_TIMESTAMP(ts) |
+------+---------------------+--------------------+
| 1 | 2008-12-31 23:59:59 | 1230767999 |
| 2 | 2009-01-01 00:00:00 | 1230768000 |
+------+---------------------+--------------------+