How to pass null as DateTime value?

Question

In a database, there is a field that saves a closure date. This date can be NOT NULL only if the case has been closed. If the case is not closed, it has to be NULL. How can I pass null value to a DateTime object?

Tried this but it doesn't work.

DateTime closure= dateDatumIspisa.SelectedDate ?? null;
DateTime closure= dateDatumIspisa.SelectedDate ?? DateTime.Parse("");
DateTime closure= dateDatumIspisa.SelectedDate ?? DBNull.Value;
DateTime closure= dateDatumIspisa.SelectedDate ?? DateTime.Parse(DBNull.Value.ToString());

Also tried GetValueOrDefault() but it inserts DateTime.Min value, while I need this field left empty.

Any suggestions?

Jon Skeet · Accepted Answer · 2010-03-29 08:35:31Z

3

Just make closure a DateTime? instead of a DateTime. The whole point of Nullable<T> is to make a nullable type from a non-nullable one.

Now, you haven't shown the type of SelectedDate - but if it's already a DateTime? then you don't need to use ?? at all. Just:

DateTime? closure= dateDatumIspisa.SelectedDate;

How familiar are you with nullable value types in general? You might want to read up on the MSDN coverage of them.

answered Mar 29, 2010 at 8:35

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

Comments

Aristos · Accepted Answer · 2010-03-29 08:35:33Z

1

Declare

DateTime ? closure = dateDatumIspisa.SelectedDate;

no need here to use the ?? in this line !

answered Mar 29, 2010 at 8:35

Aristos

66.7k16 gold badges117 silver badges154 bronze badges

Collectives™ on Stack Overflow

How to pass null as DateTime 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