我想在数据库日期中添加一个月,但我想防止两个月在结束时跳过一个月。类似于:select f1,f2,f3, f_date + 30 /* sort of ...:S */ from the_Table where date > ? 在我必须编码这样的东西之前知道吗?for each record in object.date + date<
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