Many Registered Voters Have An Age Of 108
Can anyone guess why? The way this happens is if you register to vote and don't provide your date of birth. If you don't provide your date of birth in some states, the system defaults to '1/1/1900'! This is the default date for many database systems including SQL Server and the AS400.
Admittedly I only thought about this for 10 seconds. Inside those 10 seconds I concluded that the reason it cannot be NULL is, that it was something that was started in the very beginning. As time went on people figured out it would be too costly to change the default now because of all the critical applications that would need to be changed that would be affected. It would bring another Y2K!
That is probably not the case but it sounds good.
I will do some research and find out why.
Until next time...
Why can't the default for a datetime field be NULL?
Admittedly I only thought about this for 10 seconds. Inside those 10 seconds I concluded that the reason it cannot be NULL is, that it was something that was started in the very beginning. As time went on people figured out it would be too costly to change the default now because of all the critical applications that would need to be changed that would be affected. It would bring another Y2K!
That is probably not the case but it sounds good.
I will do some research and find out why.
Until next time...
Comments