[sql] how to get the 30 days before date from Todays Date

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

In MS SQL Server, it is:

SELECT getdate() - 30;

Try adding this to your where clause:

dateadd(day, -30, getdate())

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