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.