How to store the release date in the database?

Question

MySQL

Strictly speaking, you need to store the release date of the game in the database subject to the following conditions:
The date can be known up to the day;
The date may be known to the month or quarter of the year, or just the year;
Dates may not be known;
With all this, it is necessary to carry out a selection taking into account: released | not released, new | old ones, indicating the time interval
How is it better to implement such

Answer 1

Perhaps the solution suggested in this question will help you

Answer 2

the most optimal is datetime null
habr