SP selecting a date range to be fine-tuned to the hour 1

[POSAPAY]

My SP runs once an hour by a SQL job is selecting from the database a number of records that have a field with a date that is not older than 5 days, yet older by a variable passed in.
The problem is, my logic only names it by DAY, and not fine-tuned to the HOUR at least.

WHERE Active = 'T' AND (DateModified BETWEEN (GETDATE()-5) AND (GETDATE()-@AlertDays))

How can I change this to have it filter to the hour or better to the second?

 

[starsky51]

Here is a neat solution to rounding GETDATE():

http://stackoverflow.com/questions/249794/how-to-round-a-time-in-t-sql

Extrapolating from that, I got these:

SELECT CONVERT(datetime, ROUND(CAST(GETDATE() AS float) * 24,0) / 24) AS RoundToHour
SELECT CONVERT(datetime, ROUND(CAST(GETDATE() AS float) * (24*60*60),0) / (24*60*60)) AS RoundToSecond

 

[POSAPAY]

Got it.. thanks!