In This How We Know TimeZone

[urmishsolanki2225]

Hear Canada 6 Time Zone , How We know Specific Time Zone For Specific City

[mpathy]

Use a TimeZone API against it, there are so many sources..

If you want to store it, you could go trough the whole SQL table via coordiantes:
https://timeapi.io/api/Time/current/coordinate?latitude=38.9&longitude=-77.03

Then save the result in a new column

Of course would be nice if already integrated here - that said, also my reminder here that the timezone belongs to the city table the country table! - but I dont know how rich he wants his database here.. So maybe you have to do it yourself