dateadd函数

sql server 官方文档非常非常全
https://learn.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-ver16&redirectedfrom=MSDN

DECLARE @startDate DATE = '2023-08-01'

DECLARE @daysToAdd INT = 10

SELECT DATEADD(day, @daysToAdd, @startDate) AS ResultDate 

ResultDate 

---------- 

2023-08-11