Enforcing a double value in SQL

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.

SQL SQL? Or Access SQL??
SQL - use the CONVERT function
If Access SQL, then CDbl oddly enough should work.

Tg

I'm using MS Sequel Server.
Can you please tell me the syntax of the "Convert" function?

Thanks.

Here is some information that I think you will find useful.

http://www.databasejournal.com/featu...le.php/2197931