This package contains time zone description tables which can be used with the MySQL server by users whose systems do not include zoneinfo files (e.g. Microsoft Windows, HP-UX).
Please don't use this package if your system includes zoneinfo files (e.g. Linux, FreeBSD, Sun Solaris)
Please generate the mysql.time_zone* tables from those files using the mysql_tzinfo_to_sql utility instead!
(Otherwise you may cause a difference in datetime handling between MySQL and other applications on your system.)
Timezone data to be used on machines where we cannot build them from the operating system's data (as we can on most UNIX-like/linux systems).
We build two timezone packages for 8.0+ releases. Each file contains SQL statements to fill the tables:
- timezone_2024b_posix_sql.zip - POSIX standard [md5 | signature]
- timezone_2024b_leaps_sql.zip - Non POSIX with leap seconds [md5 | signature]
- Installation details »
POSIX standard
This version adheres to the POSIX standard in that it does NOT include leap seconds. If you cannot built your own timezone data on your system, use this package. Most systems including Windows(TM) are POSIXly correct in this regard; if unsure, choose this download over the variant with leap seconds.
Non POSIX with leap seconds
Timezone data to be used on machines where we cannot build them from the operating system's data (as we can on most UNIX-like/linux systems).
This version does not adhere to the POSIX standard in that it DOES include leap seconds. Few people need this variant -- if at all in doubt, choose the other package.