Development MySQL

MySQL Timezone mapping to states of United states

Currently I have database having table states. I wanted to perform the timezone conversion for those states based on their timezones. Already loaded the timezone related tables and also explored convert_tz function.

What exactly I am looking for is mapping of mysql timezone with all the states of United States, Canada, Australia and Great Britain. Has anyone had better idea on this one for how to map mysql timezone to individual states.

So in this case, for example, to state arizona of United States, how would I know what timezone should I map except manually going to google.

Leave a Reply

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