Time Difference

General
1

Hi,

My scope is I want to find the time difference in seconds between the 2 dates.
My code as Below:

Dim rs4 as Recordset
Last_Connect_Time = “2016-04-18 12:38:33”
rs4 = mDB.SQLSelect(“SELECT TIMESTAMPDIFF(SECOND, '”+Last_Connect_Time+"’ , CURRENT_TIMESTAMP)")

Using Debug , I can find the difference value. But I cannot store the same in one variable.
Kindly help me out from this.

2

rs4 = mDB.SQLSelect(“SELECT TIMESTAMPDIFF(SECOND, '”+Last_Connect_Time+"’ , CURRENT_TIMESTAMP) as mytimestap")
dim MyTimeDiff as double
MyTimeDiff = rs4.field(“mytimestap”).doubleValue
rs4.MoveNext
rs4.close