MySQL 8 leap second and daylight saving time (DST) time time_zone_name table

164 Views Asked by At

When I issue this statement:

SELECT * FROM mysql.time_zone_name WHERE `name` like '%london%';

I get this list:

+---------------------+--------------+
| Name                | Time_zone_id |
+---------------------+--------------+
| Europe/London       |          451 |
| posix/Europe/London |         1059 |
| right/Europe/London |         1667 |
+---------------------+--------------+

But there is no information about support of DST, leap seconds. What is the table name I could select that information from?

If there is no table that has that information, can you please link some reliable source of that information?

I could not find that information in the documentation of MySQL 8. The only thing I found was: community package of timezones Reading it leads me into conclusion that posix/ timezones does not have leap second results, and probably right/ means it may return right in terms of exact time so potentially having a leap second. But I'm uncertain about my conclusion also I don't know if usnig the Europe/London may give result with leap second or not and if all three of them support DST.

I'm using Linux Debian for the MySQL server and client.

0

There are 0 best solutions below