Today on r/programming an interesting article about the complexity of time zones: Falsehoods programmers believe about time zones.
Tag Archives: timezone
USA Time Zones in PHP
Reply
See here for a list of US time zones.
Eastern ........... America/New_York Central ........... America/Chicago Mountain .......... America/Denver Mountain no DST ... America/Phoenix Pacific ........... America/Los_Angeles Alaska ............ America/Anchorage Hawaii ............ America/Adak Hawaii no DST ..... Pacific/Honolulu
MySQL convert_tz
Today I used the MySQL convert_tz function.
Before I could use named timezones with convert_tz I had to load the timezones.
Loading MySQL timezone data
Turns out MySQL doesn’t load timezone info by default! As you can read about here.
To load MySQL timezone info:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
Formatting timezones in PHP
All you need to know is on the date documentation…