SQL problem: Converting timestamp field into double value

[brucevde]

Is the datatype of your TimeStamp column datetime, smalldatetime or timestamp?

TimeStamp columns have nothing to do with date and/or time. It is an 8 byte binary value generated by sql server. You should only be checking for equality with timestamp columns. Also, I believe it is impossible to pass timestamp values between SQL Server and VB via strings. Use the ADO Command object with a Parameter instead.

If your timestamp column is datetime or smalldatetime, there is no reason to convert it to double.

strSQL = "select * from systemevents where timestamp >= '" & Format$(LastEventTimestampRead,"yyyymmdd") & "' ORDER BY timestamp"