What is the best way to store dates?

Question

MySQL

Good afternoon. Do not kick please - just learning.
Such question: how it is correct to store dates in MySQL (and bases basically)?
As I see it: we get a timestamp, write it to the database, when necessary - we pull it out and convert it as we like.
But I heard from many that this is a bad form and dates should be stored in DATE, DATETIME and other things, exclusively in their format.
Please consider and explain in what cases which option is better to use.
Thanks to!

Answer 1

Roughly speaking, the date is a cell in the calendar, and the time stamp is an instant, a moment in time.
You need to understand what a specific task requires - and choose.
For example.
1. I checked into the hotel on May 22 and checked out on the 26th. We are talking about days here, not specific moments.
2. We write a hit on the site in the logs - this is the moment.

Answer 2

Использование unix timestamp избавляет от всяких граблей с таймзонами, секундами координации

Answer 3

В unix t:
+ простота;
- отсутствие зон;
в дате все наоборот.

Answer 4

If you need to perform operations with dates, for example, add / subtract a day / hour / week, find the last day of the month, figure out if the year is high, find the difference in days between dates, etc. then use datetime (and things like this are done all the time).
In fact, in practice there are not so many uses for timestamp, datetime is used much more often.