To the point post - and this is a subject that burns people over and over.
Rule #1 - store datetimes in utc in your database, and back end code. Rule #2 - convert datetimes to the user's local timezone using frontend code. Rule #3 - use datetime libraries.
Source: dev.to