test sql-svr datetime for validity

  • Thread starter Thread starter John A Grandy
  • Start date Start date
J

John A Grandy

when extracting "datetime" type fields from ms-sql-svr, what is the best
method in vb.net to test for invalid values? i am assuming that the only
possible invalid value is DBNull.Value ...... correct ?
 
If you have a DateTime Field or SmallDateTime field, then you will either
have a valid date or a Null
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to assign DBNull to a SQL field? 4
inserting a datetime value into sql 10
SQLDateTime Overflow inserting DateTime that is Nothing 24
Converting an empty textbox to a null datetime field... 1
Insert statement for the DateTime field 4
How to validate Date entries. 5
best way to move a possibly null value into object from Db 3
null Datetime 2

Back
Top