SmallDateTime Min and Max Values in C#

Question

In C# there's a SqlDateTime.MinValue and SqlDateTime.MaxValue, but I can't find one for the SmallDateTime datatype from SQL Server.

var smallDateTimeMin = DateTime(1900, 1, 1);
var smallDateTimeMax = DateTime(2079, 6, 6);

Is there one or do I need to implement this myself?

Answer 1

Why not use an extension method?

public static class DateTimeExtensions
{
    public static DateTime SmallDateTimeMinValue(this DateTime sqlDateTime)
    {
        return new DateTime(1900, 01, 01, 00, 00, 00);
    }
    public static DateTime SmallDateTimeMaxValue(this DateTime sqlDateTime)
    {
        return new DateTime(2079, 06, 06, 23, 59, 00);
    }

}


DateTime date = DateTime.Now;
Console.WriteLine("Minvalue is {0} ", date.SmallDateTimeMinValue().ToShortDateString());

Admittedly, it'd be nice for extension properties, but those don't exist yet.

Answer 2

There is no smalldatetime equivalent in System.Data.SqlTypes. Nor is there an equivalent for the new datetime2 type. So I wouldn't expect min-max constants for those types in the .NET framework.

But the types are well documented on MSDN:

Date and time data from January 1, 1753 through December 31, 9999, to an accuracy of one three-hundredth of a second (equivalent to 3.33 milliseconds or 0.00333 seconds). Values are rounded to increments of .000, .003, or .007 seconds, as shown in the table.

So you can easily define your own min-max constants.