sql server query date to day 1 code example

Example 1: sql getdate minus 1 day without time

DATEADD(DAY, -30, GETDATE())

Example 2: datetime add 2 hours sql

DATEADD(HOUR, 2, GETUTCDATE())