David Garamond wrote:
> What would be the more proper way of storing birthday data? It will be
> used to send out birthday messages for customers ("Happy 30th birthday,
> Sam!"). But the date of birth is not necessarily known (in which case,
> we will only send out "Happy birthday, Sam!").
>
> I prefer using the builtin date type instead of three smallints. But I
> don't like having to arbitrarily set, say, year 1000 AD or 1 BC to
> represent "unknown year".
>
> Any thoughts?
>
How about NULL?
/Björn