select date minus 1 day sql code example

Example: sql getdate minus 1 day without time

DATEADD(DAY, -30, GETDATE())