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?
Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!