time-zone-leap-seconds

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

http://dev.mysql.com/doc/refman/5.5/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 |
+------+---------------------+--------------------+