I recommend using GM or UTC time for all values stored in a DB.
Use a a conversion module like Time::Piece for translation to
translate the DB time to a user time zone.

If my code is connecting to a database, I usually use that to do all the time arithmetic and conversion that I need...