mssql how to add 1 day to date code example Example 1: datetime add 2 hours sql DATEADD(HOUR, 2, GETUTCDATE()) Example 2: sql server today minus n SELECT GETDATE() - 1