downshiftorg / prophoto-issues

Public issue tracking for ProPhoto 6
8 stars 8 forks source link

Timezone issues #667

Closed brianium closed 8 years ago

brianium commented 8 years ago

Most timezones are stored using mysql's CURRENT_TIMESTAMP. This can be a problem if we want to display times in the user's selected timezone and the host is not using UTC for a system time.

Moving forward we should ALWAYS store timestamps as UTC, regardless of the database settings. When we pull it out we can easily set the timezone to the users WP timezone and display it in a way that makes sense :)