|
|
Posted by Roy Harvey (SQL Server MVP) on 10/24/07 15:15
On Wed, 24 Oct 2007 06:06:53 -0700, rcamarda
<robert.a.camarda@gmail.com> wrote:
>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?
To select just the rows from those intervals:
SELECT *
FROM Whatever
WHERE DATEPART(minute,LeadDate) = 0
AND DATEPART(second,LeadDate) BETWEEN 0 AND 10
Roy Harvey
Beacon Falls, CT
Navigation:
[Reply to this message]
|