How to store date of birth in database?

Question

css

First, I immediately made storage in the form of unixtime. Then he remembered that his report went in the 70s. And what to do next with those who were born before the report.

Answer 1

You can make a regular slider, or just tabs.
Tab example

Answer 2

Convert the column to DATE format (instead of DATETIME, TIMESTAMP).

Answer 3

Then he remembered that his report went in the 70s. And what to do next with those who were born before the report.

Yeah, those who came up with the unixtime format are completely stupid.

Calculations can also be made in the opposite direction using negative numbers. For example, the date October 4, 1957 00:00:00, which is 4472 days before the start of the countdown, is represented in Unix time by the number −4472 × 86400 = −386 380 800

Answer 4

Looking at the dates. If from old docks, then only as strings (otherwise you can’t push dates like February 32 in any way), if the user enters, then how convenient.