DateTime datatype

[sinha]

How to insert a null value in a column of datatype 'DateTime'? I am coding in c#.

Thanks,

[d2005]

i dont think you can
is column required????

d2005 - pure novice

[axion_sa]

The DateTime object is essentially a struct, thus it's stored on the stack (where as classes are stored on the heap). Therefore, it cannot be null.

However, this has been provided for - there are static properties that one may use: "MinValue" and "MaxValue". If you initialise the instance to (for example) DateTime.MinValue, you can perform a check against that.

DateTime myDate = DateTime.MinValue;
if (myDate == DateTime.MinValue) {
    // Your code that would be executed if the instance is not initialised.
}