SQL where Date from today minus and plus days

Question

I have codes like this:

  select CUS_Id, CUS_Name, CUS_JoinDate

  from CUSTOMER

  where CUS_joinDate between '04-12-2013' and '06-12-2013'

How can I make it 'where' CUS_JoinDate will be declare as from Today Date(minus 1 month and today + 1 month)?

So every time I run the report it will depends on the current date and it will automatically minus and plus 30 days.

Answer 1

try,

WHERE CUS_joinDate BETWEEN DATEADD(mm,-1,GETDATE()) AND DATEADD(mm,1,GETDATE())

• SQLFiddle Demo

Answer 2

You can use CURDATE() and DATEADD()

W3SCHOOLS SQL DATES