DATEADD()中月日期部分的计算方法SELECT '2012-01-29' AS [Date], CAST(DATEADD(MONTH, 1, '2012-01-31') AS DATE) AS NextDateSELECT '2012-01-31' AS [Date], CAST(DATEADD(MONTH, 1, '2012-01-31') AS DATE) AS NextDateUNION
SELECT '2013-
我需要做以下工作: and ConfirmDate > DATEADDselect tt.DaysDue from tblTaskTimeline tt where Task = 'TaskInfo') as days,ps.ProgStartDate)
注意,对于DATEADD我收到一条消息,说DATEADD需要3个参数。