How to get last 7 days data from current datetime to last 7 days in sql server

by

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())

More Related Contents:

  1. Calculating distance between two points (Latitude, Longitude)
  2. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  3. T-SQL split string based on delimiter
  4. WHERE Clause vs ON when using JOIN
  5. Partition Function COUNT() OVER possible using DISTINCT
  6. CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]
  7. Cannot use UPDATE with OUTPUT clause when a trigger is on the table
  8. CASE WHEN statement for ORDER BY clause
  9. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  10. Reference an alias elsewhere in the SELECT list
  11. Using IF ELSE statement based on Count to execute different Insert statements
  12. How to find out what is locking my tables?
  13. Passing dynamic order by in stored procedure
  14. Select SQL Server database size
  15. Check if table exists and if it doesn’t exist, create it in SQL Server 2008
  16. How do I find the data directory for a SQL Server instance?
  17. How to return default value from SQL query
  18. How to concatenate all columns in a select with SQL Server
  19. How to automatically generate unique id in SQL like UID12345678?
  20. How can I do an UPDATE statement with JOIN in SQL Server?
  21. The multi-part identifier could not be bound
  22. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  23. how can I Update top 100 records in sql server
  24. Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column
  25. Get the records of last month in SQL server
  26. Log record changes in SQL server in an audit table
  27. alternatives to REPLACE on a text or ntext datatype
  28. How to create a Date in SQL Server given the Day, Month and Year as Integers
  29. Count records for every month in a year
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment