SELECT rows with time 30 minutes or less?

Question

I have found ways on google to select rows within X amount of days, but I have a `datetime` column in my SQL Server 2008 table and would like to get the rows that have a `datetime` within the last 30 minutes. Can anyone show me how to do this? Thanks.

Accepted Answer

```
WHERE column >= DATEADD(mi, -30, GETDATE())
```

SELECT rows with time 30 minutes or less?

Solution

Problem