Default datetime sets to 1/1/1900 12:00 AM - Why?
Posted on 2006-04-06
I am using MSSQL Server 2005 to store information. I have two columns which are date/time datatypes. Users are allowed to keep the date blank in my application, effectively putting a NULL value in my database where the date should go. Instead of a NULL, I want to have a date that is obviously a NULL replacement (for indexes/performance reasons).
In the 'Default Value or Binding' option for my column, I entered '1/1/1995' (without the quotes). When I saved the changes, the database saved it as '(((1)/(1)/(1995))' (again, without the quotes). When I enter a new record without a date '1/1/1900 12:00:00 AM' comes up instead of '1/1/1995 12:00 AM'. It is okay with me that it does this, I just need/want to know why - I don't understand it. SQL server is accomplishing my task for me, but I want to understand what is going on here.