Setting SQL datetime to minimum using C# DateTime

Question

I have a datetime column in SQL Server. I believe the minimum it can be is some date in 1753 or something. My Entity Framework POCO representing the table contains a DateTime. I'd like to set the datetime in the database to the minimum it can be set to. What's the easiest way to do this?

What exactly is the purpose of doing this, if I may ask? Wouldn't a nullable datetime field be an easier sollution? — Kippie
– Kippie, Commented Jan 18, 2013 at 11:49
Not really sure if I understood you, but can't you do: DateTime sqlMinDateTime = new DateTime(1753, 01, 01); — Habib
– Habib, Commented Jan 18, 2013 at 11:56

Chris Marisic · Accepted Answer · 2024-04-25 18:21:50Z

18

That value can be retrieved using the following property;

SqlDateTime.MinValue.Value

See http://msdn.microsoft.com/en-us/library/system.data.sqltypes.sqldatetime.minvalue.aspx for more details.

edited Apr 25, 2024 at 18:21

Chris Marisic

33.2k30 gold badges169 silver badges265 bronze badges

answered Jan 18, 2013 at 11:50

Chris McAtackney

5,2428 gold badges50 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ta.speot.is Over a year ago

I don't understand the downvote. SqlDateTime has an implicit conversion to DateTime, I believe, so this should work just fine.

Stephen Byrne Over a year ago

You need to use System.Data.SqlTypes.SqlDateTime.MinValue.Value, which is a DateTime.

Collectives™ on Stack Overflow

Setting SQL datetime to minimum using C# DateTime

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related