“MySQL converts TIMESTAMP values from the current time zone to UTC for
storage, and back from UTC to the current time zone for retrieval. (This does
not occur for other types such as DATETIME.)”
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
So, change your field type to DATESTAMP and it shoudl do what you want.
Antony.