DECLARE @e DATETIME = '2021-02-05 12:30'
SET @e = DATEADD(yy, DATEDIFF(yy, @e, GETDATE()), @e)
SELECT @e
sqlsever 快速修改年份
于 2022-04-01 21:21:07 首次发布
DECLARE @e DATETIME = '2021-02-05 12:30'
SET @e = DATEADD(yy, DATEDIFF(yy, @e, GETDATE()), @e)
SELECT @e