How to get last 7 days data from current datetime to last 7 days in sql server
Try something like: SELECT id, NewsHeadline as news_headline, NewsText as news_text, state CreatedDate as created_on FROM News WHERE CreatedDate >= DATEADD(day,-7, GETDATE())