Databasen - NULL dates
Jurgen Pletinckx
jurgen.pletinckx at algonomics.com
Wed Oct 18 14:10:57 BST 2006
| Well, let's say we have:
|
| 1) As yet unknown, will possibly be known in the future (date
| of death,
| employee resgination)
|
| 2) Unknowable (end of the universe)
|
| If something falls into category 2 then why model it at all? It is a
| constant.
Perhaps unknowable was the wrong word. Unknown, then? As in "We know
this happened, but can't possibly assign a correct date" for fields
where a unambiguous date was assumed, such as blood sample collection.
(Anecdote omitted - I'm sure everyone has horror stories.)
--
Jurgen Pletinckx
AlgoNomics NV
More information about the london.pm
mailing list