how to get the 30 days before date from Todays Date

Question

how to get the 30 days before date from Todays Date. in Sql using Query

Answer 1

T-SQL

declare @thirtydaysago datetime
declare @now datetime
set @now = getdate()
set @thirtydaysago = dateadd(day,-30,@now)

select @now, @thirtydaysago

or more simply

select dateadd(day, -30, getdate())

(DATEADD on BOL/MSDN)

MYSQL

SELECT DATE_ADD(NOW(), INTERVAL -30 DAY)

( more DATE_ADD examples on ElectricToolbox.com)

Answer 2

In DB2, you can use:

select current date - 30 days as some_time_ago from sysibm.sysdummy1;

You can actually do all sorts of wondrous datetime additions and subtractions such as:

current date + 2 years + 3 months + 10 days
current time + 4 hours - 6 minutes + 10 seconds
days(current date) - days(date('2010-01-01'))

Answer 3

SELECT TRUNC (SYSDATE - 30) FROM DUAL;

Executed today using ORACLE PL/SQL, it will produce:

April 14th, 2010 00:00:00