469,906 Members | 2,189 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,906 developers. It's quick & easy.

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

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.
Jan 16 '07 #1
2 2449
iam_clint
1,208 Expert 1GB
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
Jan 16 '07 #2
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.
Jan 16 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.