datetime C# equvalent

[rakk]

I have the following table column

[hire_date] [datetime] NOT NULL DEFAULT (getdate()),

Then using Linq I try the following

employee e1 = new employee
{
.....
hire_date = new DateTime()
};

And I get this error:

SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

What is the C# equivalent for MSSQL datatime database type ?

[eclipsed4utoo]

I don't think there is one. I normally set a static global variable to the "1753" date and just use that when instantiating dates.

[rakk]

I don't think there is one. I normally set a static global variable to the "1753" date and just use that when instantiating dates.

like this
new Datetime("1973") ?

[eclipsed4utoo]

no, like

Convert.ToDateTime("1/1/1753 12:00:00 AM");

[rakk]

Thank you.

[sknake]

DateTime maps to SQL's datetime, but the valid range is different. To initialize a DateTime with the minimum value use:
System.Data.SqlTypes.SqlDateTime.MinValue.Value