Java Qui Nhon: MySQL Timezone tables

https://dev.mysql.com/downloads/timezones.html
https://dba.stackexchange.com/questions/149492/i-cant-find-time-zone-tables-in-sys-database-of-mysql

I used to face the same issue as you and I resolved it by following these quick steps.

Please follow below:

Environment:

Steps:

Download the package that contains the data files of pre-built time zone tables. You can download here https://dev.mysql.com/downloads/timezones.html
- timezone_2018e_posix_sql.zip - POSIX standard for MySQL version 5.7
Extract the downloaded package, you will then have a file named timezone_posix.sql
Open a command line in the root directory of MySQL. Ex: On my computer this is "C:\Program Files\MySQL\MySQL Server 5.7\bin"
Run the command mysql -u root -p to login to MySQL with root access and then enter password.
Run the command show databases; to view all database. You will see a database named mysql. You need to insert data into the mysql database
Finally, you can insert data by issuing the command source /path/to/timezone_posix.sql.

After inserting the timezone data, you can test by issuing the following query:

 SELECT CONVERT_TZ('2018-07-02 14:46:46','utc','America/Los_Angeles')

If the result is not null, you're successful!!!

Java Qui Nhon