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.