Re: Zip code to Time Zone

jcastr02 · ‎11-22-2023

I have a list of US Zip Codes and would like to know what timezone it's in. Does anyone know a good source or best way to achieve this? Thank you.

AmiraBedh · ‎11-22-2023

These databases can be integrated into your system, allowing for quick lookups. This is a good option if you need to do this conversion regularly.

Zip Code Range by State (structnet.com)

List of time offsets by U.S. state and territory - Wikipedia

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

jcastr02 · ‎11-28-2023

Thank you @AmiraBedh do you have a database that is specific to timezone to zip code. I'm concerned to use zip to state to timezone as some states may have two different timezones in it. Thanks so much.

AmiraBedh · ‎11-28-2023

I don't have any certain info about your matter (and I think it is not directly linked to PBI) but you can check these websites :
Zipinfo.com

Free Zip Database

Simplemaps.com

GreatData.com

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696