Timestamp Inconsistency

Timestamp Inconsistency

tgix
Member
Posts: 158
Threads: 28
Joined: May 2016
Reputation: 4

09-12-2020, 10:39 AM

As pointed out - the database may also be in another timezone. For MySQL I always do a "SET time_zone='+00:00'" after connecting to the database and then make sure all times are handled in UTC and only changed when presented to the user (based on the user's timezone settings).

Messages In This Thread

Timestamp Inconsistency - by Gary - 09-08-2020, 05:34 AM

RE: Timestamp Inconsistency - by MGatner - 09-10-2020, 03:07 PM

RE: Timestamp Inconsistency - by Gary - 09-12-2020, 08:44 AM

RE: Timestamp Inconsistency - by tgix - 09-12-2020, 10:39 AM

RE: Timestamp Inconsistency - by Gary - 09-14-2020, 05:45 AM