Koen Verbeeck (11/26/2012)
Nice question. The explanation could be a bit more clear.It's not the default from the default expression GETDATE(), but the default value that is chosen when 0 or space is converted to a datetime.
+1
Bear in mind that for DATETIME data types, the Date part is stored as the number of days since "1900-01-01".
Therefore, when a 0 (or space , which is "converted" to 0) is inserted, it will equate to said "1900-01-01".
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”