I'm writing a VB app which sends an SQL statement to SQL Server:

strSQL = "select * from systemevents where timestamp >= " + CStr(LastEventTimestampRead) + " order by timestamp"

strSQL = the SQL statement
timestamp = field with date and time value, in date and time format.
LastEventTimestampRead = double variable from external source, representing a time value.

How do I convert the timestamp value into a DOUBLE value, so I can compare it with the LastEventTimestampRead variable? I tried CDbl but that' a VB command and not SQL.

Thanks.