MinDate not updating in SQL 2008 Date

Question

this is weird.  Any other date works, but when I send back MinDate  1/1/0001 12:00:00 AM to SQL 2008's Date field, it remains the default which I have set to null in the databse for that field:

conn.AddParam("@birthDate", birthDate);

birthDate is type DateTime.  It's set to DateTime.MinValue;  I don't see why it wouldn't take this.

---

C# Web Developer

Answer 1

1/1/0001 is an unknown value to SQL Server.

DECLARE @t DATETIME = '1/1/0001'
SELECT @t

Msg 242, Level 16, State 3, Line 1

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

But this works:

DECLARE @t DATETIME = '1/1/1753'
SELECT @t

1753-01-01 00:00:00.000