How do you subtract 30 days from current date in SQL?

How do I subtract days from current date in SQL?

MySQL DATE_SUB() Function1Subtract 10 days from a date and return the date: SELECT DATE_SUB("2017-06-15", INTERVAL 10 DAY);2Subtract 15 minutes from a date and return the date: ... 3Subtract 3 hours from a date and return the date: ... 4Add 2 months to a date and return the date:MySQL DATE_SUB() Function - W3Schools

How can I add 30 days to current date in SQL?

Using DATEADD Function and Examples1Add 30 days to a date SELECT DATEADD(DD,30,@Date)2Add 3 hours to a date SELECT DATEADD(HOUR,-3,@Date)3Subtract 90 minutes from date SELECT DATEADD(MINUTE,-90,@Date)4Check out the chart to get a list of all options.Add and Subtract Dates using DATEADD in SQL Server

How can I get 30 days before a date in SQL?

SELECT (column name) FROM (table name) WHERE (column name) < DATEADD(Day,-30,GETDATE()); Example.

Can you subtract date in SQL?

Discussion: If you would like to subtract dates or times in SQL Server, use the DATEADD() function. It takes three arguments. The first argument is the date/time unit – in our example, we specify the day unit.