Enforcing a double value in SQL

[Dr.Rock]

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.

[techgnome]

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

Tg

[Dr.Rock]

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

Thanks.

[Hack]

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

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