Databasen - NULL dates

[Peter Corlett]

On Wed, Oct 18, 2006 at 10:51:41AM +0100, Nigel Rantor wrote:
> So, have been interviewing DB types lately, looking for a Guru.

> We got into a discussion about whether or not to use NULL values for dates
> that are as-yet-unknown. anyone have strong feelings and arguments either
> way?

The *whole point* of a NULL field is that it's data that is unknown. That's
why you get such "strange" results from operations when you're involving
NULL values - the results make a lot more sense when you realise what NULL
*means*.