When doing apps that deals with date there almost always comes a question on
how to store an incomplete date.
Person A is born on 1980-02-17.
Person B is born on 1980-02 <- The person doesn't know the exact day (This is acctually a real life scenario)
How to store this wisely in db? You can't really put a datetime DateOfBirth Column.
I usually take 3 int columns (year, month, day) with constraints but i'm wondering...
Does anyone know of a better method?