ASP: Compare time stored in sql to server to present time

[knoxvegas]

I have a table that will be storing the time I want to compare with the current time of an action. Any help appreciated. I'm new to asp programming.

[iam_clint]

http://www.w3schools.com/vbscript/func_datediff.asp

refer to this link, although this is vbscript it will still work change the document.write to response.write

[knoxvegas]

Yeah, I've seen that. The explanations stink. I ended up getting my answer from a friend.

SELECT DATEDIFF(HOUR, hr_compare, GETDATE()) FROM dbo.v_wo_run_history


This will actually return the hour difference for me. Now I need to figure out how to make the recordset data into something I can manage with vbscript. Like make the value a variable.