hi. i'm creating an asp page using vbscript. i create and execute a string as an SQL statement.

problem:

strSQL = ..... " ' " & Date() & " ' " .......... <-- this works
strSQL = ..... " ' " & Time() & " ' " .......... <-- this does not

i get a string conversion error. i'm storing the time as the data type TIME in my SQL table.

What type of DB do you have? This probably has nothing to do with the issue, but you don't need spaces before and after your date or time value:

strSQL = ..... " '" & Date() & "' " ..........

i figured it out stupid mistake

strSQL = ..... " ' " & Time() & " ' " ..........

should be

strSQL = ..... " ' " & FormatDateTime(Time(), vbShortTime) & " ' " ..........

argh