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 =.