Help update my db with Date and Time stamps

Andi03

Active member
Joined
Sep 5, 2003
Messages
43
Hi

Im using ASP.NET in my page with VB.NET code.

But I have a problem with a SQL-string
 
Hmmm... you may need to use apostrophes before and after your TimeOfDay value.

Code:
VALUES(" & Today & ", " & Right(TimeOfDay, 8) & ")"

Its a barely-educated guess.
 
nopp didnt work. I get this then:
System.Data.OleDb.OleDbException: Typemixing in the expression (badly translated from swedish)
 
Back
Top