How to Get date after 30 Days in SQL

Question

I am currently developing an MVC solution with an SQL Server database, and I need to retrieve the last modified rows in the last 30 days, how can I do this using SQL.

Answer 1

Get Date after 30 Days in SQL

To obtain a date in the last 30 days using an SQL query, you can use the below query:

select  *  from [Table] where Cast([ModifiedDate] as date) = Cast(DATEADD(day,-30, getdate()) as date)