ansaurus

Question

Is there a standard way to represent TSQL Minimum date in ASP.NET

Answer 1

+1 A:

EDIT: Luke is right, extension methods are not an appropriate solution to this problem.

Nebakanezer 2009-12-07 16:24:22

The fact that you can only call extensions on instances of a type rather than the type itself could lead to some *very* unintuitive code: `var confusing = new DateTime(2009, 12, 07).SQLMinValue();` etc.

LukeH 2009-12-07 16:29:32

Very good point Luke. This is not the appropriate use of extension methods. Thanks for pointing this out.

Nebakanezer 2009-12-07 16:32:07

Thanks Luke, I didn't know that, useful point :)

Mahesh Velaga 2009-12-07 16:50:32

Answer 2

+6 A:

System.Data.SqlTypes.SqlDateTime.MinValue;

...and the MSDN documentation for reference.

Justin Niessner 2009-12-07 16:27:15

If I have to compare it with some DateTime value, is it fine if I do DateTime.Now != (DateTime) SqlDateTime.MinValue or is there a better way to do that? Thanks for the answer :)

Mahesh Velaga 2009-12-07 16:49:31

I can't remember if you can directly cast from SqlDateTime to DateTime. If not, then you could do DateTime.Now != new DateTime.Parse(SqlDateTime.MinValue.ToString());

Justin Niessner 2009-12-07 18:14:44

ansaurus

tags:

views:

answers:

Is there a standard way to represent TSQL Minimum date in ASP.NET

related questions