Timezones?

[wrabit]

How can we add timezone to each city?

[khsing]

sure, but we need data source to do this.

[seche]

https://download.geonames.org/export/dump/ seems like a good source. Has a few dumps for cities by population. And they all link to an IANA Timezone which is what PHP uses.

@khsing did you prefer to add a timezone field in cities or a new timezone table with abbreviation and time offsets? PHP comes with DateTimeZone::Class that handles the information as needed and I think the table might be redundant. Could easily have the functionality with a timezone trait.