|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Date Diff Routine |
|
From: |
Jordi |
|
Date: |
12/24/2003 4:40:13 AM |
|
IP: |
195.77.33.58 |
I would do this:
sql = "select 'YES' AS NeedsUpdate FROM Calls WHERE datediff(hh, columntime, getdate())>4 "
set rst = objconnection.execute(sql)
while not rst.eof
wend
res the problem I have a table called "calls" I need to do a date diff between the column time and Now(). If the difference is greater than 4 hours then an upadate needs to be done to change the priority column in the same table. Phew |
Previous Message
Follow Up - Re: Date Diff Routine - Jordi 12/24/2003 4:44:24 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
