Posted by rcamarda on 10/24/07 13:06

I have rows of data that have a datetime stamp. I need to find rows
that have a datetime stamp within 10 seconds of the top of each hour.
I started with datediff(s,getdate(),LeadDate) but I am stumped on how
to process for each hour.
I.E. records between 9:00:00 and 9:00:10 , 10:00:00 10:00:10, and so
forth for each hour.
Ideas?

• Next in forum: Re: view
• Prev in forum: Re: pass Column Name using Parameter in SQL Statement...
• Thread view: find rows within seconds of top of hour

[Reply to this message]