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?
--
dave