Data for last hour

[Cooldood]

I can get data for one day using  > GetDate() - 1   

How do I get data for last hour ?

[Tim_N]

You might try DATEPART(interval, date). There's other syntax within each of the interval and date that you can use to pin-point your work. At least maybe that's a helpful starting point. 🙂