sql getdate minus 1 day without time
snippet in sql

sql getdate minus 1 day without time

user925

DATEADD(DAY, -30, GETDATE())