Find last hour 1

[IanWaterman]

I need to run a report hourly and data must be returned from entries in last hour. Report will be scheduled but will not execute exactly on the hour.

If report runs at

26/04/2010 11:05:00 I must filter data where

datetimefield >= 26/04/2010 10:00:00 and
datetimefield < 26/04/2010 11:00:00

Once I have one of the times I can derive the other by using dateadd to add or subtract 1 hour.

Thank you

Ian

 

[RiverGuy]

Try this

DECLARE @EndDate DATETIME
DECLARE @StartDate DATETIME
SELECT @EndDate = CONVERT(DATETIME, CONVERT(VARCHAR(13), GETDATE(), 127) + ':00:00.000')
SELECT @StartDate = DATEADD(hour, -1, @EndDate)

PRINT @StartDate 
PRINT @EndDate

 

[IanWaterman]

Perfect.

Thank you

Ian