471,092 Members | 1,498 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

WAITFOR DELAY '000:00:05'

Env: SQL Server 2000

It actually waited for 50 seconds instead of 5, tried
WAITFOR DELAY '000:00:005' and WAITFOR DELAY '000:00:5' respectively,
and got same behavior. Bug or ?

TIA

Jul 23 '05 #1
3 22403
WAITFOR DELAY '000:00:005'

Well as you know the the time value you pass is a datetime value minus
the date part.

Now what is the smallest precision of time is datetime? Does it make
any sense to use 005 in place of 05 if what you really want is just 5
sec. If you want to look deeper into this and a smaller unit than a sec
try using:
WAITFOR DELAY '000:00:05:05'
Regards
Debian
*** Sent via Developersdex http://www.developersdex.com ***
Jul 23 '05 #2
All right, 005 was thoughtless. And yet the strangest thing is, now,
WAITFOR DELAY '000:00:05' waited for 5 seconds as intended while a few
hours ago it waited for 50 seconds on the same machine. Well, it seems
that the machine is definitely not MINE.

Jul 23 '05 #3
Stu
Did you check the CPU activity and other indicators of resource
utilization while it was WAITING? Could be something else was going
on....

Stu

Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.