I have a table with several date field. The particular field is a timestamp with default '000-00-00 00:00:00'. There are two row types. One row type always has a date int the field in question. The other type presently has '000-00-00 00:00:00' because no value has been loaded there. There is an index on this field.
It is our intention at some point to also populate this field for the other row type.
My question is the following: would it be better to change the default zero to a null?