This article is tagged with:
Sql getdate minus 1 day without time
and mysql
sql getdate minus 1 day without time
DATEADD(DAY, -30, GETDATE())