Databasen - NULL dates

Peter Corlett abuse at
Wed Oct 18 16:04:17 BST 2006

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

More information about the mailing list