Storing dates/times as UTC in your database. What's your thoughts?

Hi All,

I’m curious what everyone thoughts are on storing dates/times as UTC in the database… as a general rule of thumb it seems to be recommended.

My understanding is that you would store times in their UTC format in the database and would always need to be converting it to the users local time in the front end, and then converting any of their inputs back into UTC time to store in the DB?

What if all of your users were from the one country, or Timezone. Would you still do it?

Any thoughts or input appreciated… just a general chat about time storage in the DB’s :slight_smile:

Community Page
Last updated: