When doing apps that deals with date there almost always comes a question on
how to store an incomplete date.
For example:
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?
Print | posted on Saturday, February 17, 2007 2:05 AM | Filed Under [ SQL Server ]
Powered by:
Copyright © Mladen Prajdić