Date with VB.net

[WJProctor]

Hi, In the data structure for one of my tables ive set one field to be a date. In VB how do i format the date to enter it into this field because i seem to be having some problems getting it right. I also would like to save the time in this field which i belive is possible from my tests. Hope someone can help

Regards

JP

 

[SQLBill]

1. Is your table in Microsoft SQL Server?
2. Is your date field a DATETIME datatype?

You could have it entered as:

2003-12-15 09:00:00

-SQLBill

 

[krinpit]

A quick way to enter just the date into a datetime column is:
CONVERT(DATETIME, '12/15/2003', 102)