time >
datediff

time different between 2 time

Datediff("how_to_count",oldTime,newTime)
how to count :h,m,n,q,ww,w,yyyy,y,s,d
h=hour
m=month
q=quarter
y=which date of a year
yyyy=which year
d=which date of a month
n=minute
s=second
ww=which week of a yeay
w=which day of a week

<%

response.write Datediff("h",Time1,Time2)

%>
----------------------------------------------
<%
Set rs= conn.Execute ("select * from aTable " )
if not rs.eof then 
 id=rs("id")
 FT=rs("Ftime")
 DD=DateDiff("h",FT,now)
   if DD>48 then
   SQLDelete = "Delete  from aTabl1 where id1='"&id&"'" 
   conn.Execute SQLDelete
   end if
end if
%>
similar to dateadd:

SQLCheckHits="SELECT SUM(county) AS sumHits  from TB1 
where Time1 > ' " & DateAdd("h",-8,now) & " ' "

Set RSCheckHits = Server.CreateObject("ADODB.Recordset")
RSCheckHits.Open SQLCheckHits,conn
sumHits= RSCheckHits("sumHits")
RSCheckHits.close

delete all rows which time different is bigger than 48 hours