is it possible to get the timezone of a datetime - field?

Question

everything that I have read about timestamp and datetime in mysql suggests that it is not possible to find out the timezone of a datetime - Field in mysql.

If that is true, isn't that a big advantage of timestamp - values compared to datetime - values?

For example if by mistake the default-time-zone is changed and there are stored some datetime-values with

now()

you will have a hard time to fix the wrong values. Whereas with timestamp you can just set the timezone you want to have and the database changes the entries automaticly because it stores them always in UTC.

___Note:___ Drawback with TIMESTAMP - _TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC._ — RiggsFolly, May 04 '20 at 11:18
Avoid `TIMESTAMP` since is flawed at this point. It will run out of values in 2038. — The Impaler, May 04 '20 at 11:54
I think this will be updated when we are near the year 2038. timestamp would be not useable anymore if thats not the case, right? — Matthias Gwiozda, May 04 '20 at 13:07

artoodetoo · Answer 1 · 2020-05-04T12:34:29.550

is it possible to get the timezone of a datetime - field?

No, you cannot get timezone info from the DateTime column because it doesn't have such information.
Perhaps, the system or server timezone is what you are looking for.

isn't that a big advantage of timestamp - values compared to datetime - values?

It depends on the context. Use a suitable data type for columns. Not always you need to change the presentation of date+time if your server moved to another location. Rather, on the contrary, once stored data must remain unchanged in most cases.

See:

is it possible to get the timezone of a datetime - field?

1 Answers1