Maybe I'm not understanding the question but best practice is usually to store everything in the database in UTC time (or epoch time) and do the conversion usin

Maybe I'm not understanding the question but best practice is usually to store everything in the database in UTC time (or epoch time) and do the conversion using a localtime offset when you display it.