vbscript & sql

[softie()]

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.

[endersshadow]

Try it like this:

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

And let me know what happens.