|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
