MySQL Forums
Forum List  »  Newbie

Re: Automatic timezone assigned to inserted value
Posted by: Peter Brawley
Date: June 11, 2021 12:51PM

Timestamps convert to UTC based on the time_zone setting, convert back on retrieval.

DATETIME columns store date and time independently of time_zone settings

So your solution for this issue depends on your time_zone setting and how your system manages time zone. More info in the manual of course.

Options: ReplyQuote

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.