Setting Date/Time variable to nothing (empty)

[trisolve]

How do i set the date/time variable to nothing. e.g for string we could do as follows:

mystr = ""

but this doesn't work for datetime variable. Help please

thanks

trisolve

[mocella]

Depends on what database you're using, but it's either:

DBNull.Value

or

SqlDateTime.Null

[Bucky]

Because all value types resolve to reference types in the .NET

Framework, you can just set the variable to Nothing (in VB) or null

(in C#).

[trisolve]

mocella, i tried your method but I don't think I understood it right. If you can give me an example that would be great.

Bucky, I tried setting the value to nothing but all it does is it sets the variable time to its default that is 12:00:00 AM. thanks

[mocella]

This link may help you a bit:

http://www.dotnetjunkies.com/Article/6B4436E7-5913-41CC-A139-095C14AF5552.dcik

 

 

However, you may need to see how that database column is defined - it may default to that datetime when null is inserted.

 

I wish I had my laptop here to check on how I've done this sort of thing, but I'm not back to work until the 5th. Did I just say I miss work???

[Bucky]

When you access a DateTime variable that has been set to

Nothing, then it will initialize and return the default value. Instead

of retrieving its value, just check to see if it's equal to Nothing.

 

Here x is the DateTime variable:

If x = Nothing Then
 ' x is set to default value
End If

 

Note that for reference types you use the Is keyword to compare

objects. For comparing a value type (x, the DateTime) with a

reference type (Nothing), as is the case here, you use =.