select datediff(mi,'2008-3-14 14:32:00',getdate()) select 24*60*3 if datediff(mi,'2008-3-13 15:51:00',getdate()) > 24*60*3 print 'aa' else print 'bb'
datediff("n",strExpires,Now()) > 4320