MySQL Forums :: General :: Storing timezone with datetime

Neither datatype stores the TZ explicitly.

TIMESTAMP is seconds since 1970, sitting in 4 bytes. It is stored in GMT. That is, the TZ offset is applied as you store a value, then reapplied when you fetch it. If you are storing and fetching from the same computer, you won't notice these two conversions.

DATETIME is an 8-byte string of digits "yyyymmddhhmmss". It is more like recording what the clock says, not what time it is in some global sense.

That's two ways of dealing with time. There are actually something like 5. You are on your own if the above two flavors of date+time don't do what you need.