Olson Timezone Database Download

Image Credit

Hope you’ve came here because of the following reasons:

  1. In the lookout for the PHP Timezone Database in SQL format
  2. Your php timezone database is corrupt
  3. For php olson timezone/tz database
  4. pear timezone bug
  5. pear timezone install failures

Then here is the solution:

The following PHP Timezone Database in MySQL format contains all the available timezones in PHP(416 in total) based on http://php.net/manual/en/timezones.php

How to use:

  1. Download the zip file
  2. Import the downloaded file to any database using the MySQL command-line or using any of the MySQL database management tools like phpMyAdmin
  3. Roll on the floor and say thank you to Mithun John Jacob(that’s me!) 🙂

P.S: This MySQL data can be used for any programming language and not for PHP alone.



Leave a Reply

Your email address will not be published. Required fields are marked *