Compare Nullable DateTime variable for default value

Question

In my C# code, I have a DateTime? variable. While getting the values from database it can be null or can have some date/time value.

On the front end side I don't want to get the default value (01-01-1900 12:00:00 am). Whats the best way to compare my date variable for this default date?

Maybe you should have the database store null instead of "01-01-1900"? — Torben Koch Pløen
– Torben Koch Pløen, Commented Oct 17, 2012 at 7:11
I second Torben. but then again if your database will never use that date then go ahead - no point doing much workaround for a little thing that doesn't bother your app. — mauris
– mauris, Commented Oct 17, 2012 at 9:03

Adam Kostecki · Accepted Answer · 2012-10-17 07:16:11Z

6

You can create a const:

static readonly DateTime DefaultDateTime = new DateTime(1900, 1, 1, 0, 0, 0);

and then compare this way:

DateTime? myVariable = returnedFromDb == DefaultDateTime ? default(DateTime?) : returnedFromDb;

answered Oct 17, 2012 at 7:16

Adam Kostecki

3011 silver badge3 bronze badges

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

Comments

Angela_SB · Accepted Answer · 2012-10-17 07:28:06Z

3

You can have an extension method, something like this:

public static class DateTimeExtensions
{
    static DateTime SQL_DEFAULT = new DateTime(1900, 1, 1);

    public static bool IsDefaultValue(this DateTime dateTime)
    {
        return dateTime == SQL_DEFAULT;
    }
}

And then just test the value:

var isDefault = myDate.IsDefaultValue();

answered Oct 17, 2012 at 7:28

Angela_SB

2494 silver badges12 bronze badges

Collectives™ on Stack Overflow

Compare Nullable DateTime variable for default value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related