Time query

[Bhavin]

What should be SQL statement in asp to update time field
(in MSACCESS) with current time?

 

[Ken Schaefer]

strSQL = "UPDATE myTable SET myTimeField = Time()"

Time() is an inbuilt VBA function that returns the current system time.

Cheers
Ken

: What should be SQL statement in asp to update time field
: (in MSACCESS) with current time?