mysql - Regarding the issue of time storage, do you guys use the local time or UTC time when you save the database time?

Question

As the title states, there is a question about time storage. When you store the time in the database, do you use the local time or the UTC world time?

Answer 1

Save the timestamp, what if you want world time? →_→

Answer 2

Of course, take the UTC world time in East 8th District

Answer 3

Of course it’s UTC time

Answer 4

Certainly cannot use database time. For example, you click a button on the page to save a piece of data into the database. There may be some reasons for this process. The time you clicked is 12:00, but the time when the data is saved is 12:01. In this case, the data is wrong. It is said above that getting the timestamp is very reliable. When you click, the timestamp will be put into the data. As for when the database saves it, it doesn't matter. Anyway, the corresponding timestamp is saved at 12:00, and it will always be 12:00 whenever you view it.