Store UTC date time in database

Question

I will convert all date & time input by user (local time) to UTC and store it in database. When display back I will convert UTC time to their time zone which is set in their profile. Is it good?

Answer 1

I think it's good enough. Besides storing user timezone in profile, you can also let client (for example, javascript) convert UTC time according to user computer time zone.

Answer 2

As long as you can convert to/from any time zone from your stored DB records, that's all you need.

What you've described will work.