How to subtract 30 days from the current date using SQL Server

by

You can convert it to datetime, and then use DATEADD(DAY, -30, date).

See here.

edit

I suspect many people are finding this question because they want to substract from current date (as is the title of the question, but not what OP intended). The comment of munyul below answers that question more specifically. Since comments are considered ethereal (may be deleted at any given point), I’ll repeat it here:

DATEADD(DAY, -30, GETDATE())

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  3. Convert Date format into DD/MMM/YYYY format in SQL Server
  4. Cannot Resolve Collation Conflict
  5. Try_Convert for SQL Server 2008 R2
  6. SQL Server: +(unary) operator on non-numeric Strings
  7. How to automatically generate unique id in SQL like UID12345678?
  8. Is it possible to write single query on two table which are not connected to each other?
  9. Identity increment is jumping in SQL Server database
  10. sql server 2008 management studio not checking the syntax of my query
  11. Split function equivalent in T-SQL?
  12. Is the NOLOCK (Sql Server hint) bad practice?
  13. How to create a table from select query result in SQL Server 2008 [duplicate]
  14. How to find all connected subgraphs of an undirected graph
  15. Parse comma-separated string to make IN List of strings in the Where clause
  16. OPTION (RECOMPILE) is Always Faster; Why?
  17. Rename column SQL Server 2008
  18. Compare DATETIME and DATE ignoring time portion
  19. Split function in SQL Server 2008
  20. Remove numbers from string sql server
  21. How do I edit a table in order to enable CASCADE DELETE?
  22. Using PIVOT in SQL Server 2008
  23. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  24. Function in SQL Server 2008 similar to GREATEST in mysql?
  25. SQL Server SELECT LAST N Rows
  26. Find min and max for subsets of consecutive rows – gaps and islands
  27. How can I group by date time column without taking time into consideration
  28. The transaction log for the database is full
  29. Select SQL Server database size
  30. How to execute a stored procedure inside a select query

Leave a Comment