last 30 days sql code example

Example 1: sql last 7 days

SELECT id, NewsHeadline as news_headline, NewsText as news_text, state CreatedDate as created_on
 FROM News 
 WHERE CreatedDate >= DATEADD(day,-7, GETDATE())

Example 2: 3 days back in sql server

DATEADD(DAY, -3, GETDATE())