how to get the 30 days before date from Todays Date

Question

How do you get the 30 days before today in SQL.

edit: according to your previous question, it's obviously ms sql. — hgulyan, May 14 '10 at 10:05

amelvin · Accepted Answer · 2010-05-14T10:43:01.547

143

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

MYSQL

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

edited May 14 '10 at 10:43

answered May 14 '10 at 10:00

amelvin

Just realised, this is written in T-Sql (Sql Server), if the answer is needed for MySql then something like: SELECT DATE_ADD(NOW(), INTERVAL -30 DAY) is the equivalent. – amelvin May 14 '10 at 10:05
1

Just add this to your answer:) – hgulyan May 14 '10 at 10:09
In MySQL, DATE_SUB(NOW(), INTERVAL 30 DAY) works as well – radtek Jul 20 '15 at 14:39

score 18 · Answer 2 · edited Aug 20 '12 at 17:49

18

In MS SQL Server, it is:

SELECT getdate() - 30;

edited Aug 20 '12 at 17:49

Gaffi

answered May 08 '11 at 03:35

Merin Nakarmi

1

What is the difference Gaffi? Why you think edit was necessary? – Merin Nakarmi Aug 23 '12 at 16:38
1

I think the only relevant difference in the original and the edited version is that the latter uses the `` tag, which looks better. :) – Sk8erPeter Aug 01 '13 at 10:21

score 3 · Answer 3 · edited Mar 05 '18 at 09:01

3

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

Example.

SELECT `name`, `phone`, `product` FROM `tbmMember` WHERE `dateofServicw` < (Day,-30,GETDATE());

edited Mar 05 '18 at 09:01

Community

answered Aug 03 '16 at 05:07

Ashley2605

score 0 · Answer 4 · edited Feb 26 '20 at 06:24

0

Try adding this to your where clause:

dateadd(day, -30, getdate())

edited Feb 26 '20 at 06:24

jalsh

answered Feb 26 '20 at 03:12

4 Answers4