Hi, I ask if Wappler’s UTC should be the same as GMT because, in my app, whenever a user logs on, I update the User row with a Local and a UTC datetime. Then I have a database view to calc my timezone from the difference between the 2 dates, in hours. Not saying this is the best way to go, just a way.
Anyway, what I have found is that the Local Time in the database is correct, but the UTC is 4 hours out compared to GMT. Not sure if this matters, just not what I was expecting.
These two screen shots are taken a minute apart, and by the way, my timezone should be +8hrs not +12hrs as is calculated.
Values stored in mySQL after an Update following a Login.
GMT according to Google
Does anyone else get this?
I almost think that this does not matter so long as the UTC is consistent from any place in the world. Your thoughts?
Last updated: