SELECT '现在' AS [日期], GETDATE() AS [数据]
UNION ALL
SELECT '下一秒' AS [日期], DATEADD(ss, 1, GETDATE() ) AS [数据]
UNION ALL
SELECT '下一分' AS [日期], DATEADD(mi, 1, GETDATE() ) AS [数据]
UNION ALL
SELECT '下一小时' AS [日期], DATEADD(hh, 1, GETDATE() ) AS [数据]
UNION ALL
SELECT '明天' AS [日期], DATEADD(dd, 1, GETDATE() ) AS [数据]
UNION ALL
SELECT '下周' AS [日期], DATEADD(ww, 1, GETDATE() ) AS [数据]
UNION ALL
SELECT '下月' AS [日期], DATEADD(mm, 1, GETDATE() ) AS [数据]
UNION ALL
SELECT '下季度' AS [日期], DATEADD(qq, 1, GETDATE() ) AS [数据]
UNION ALL
SELECT '明年' AS [日期], DATEADD(yy, 1, GETDATE() ) AS [数据]
go
日期 数据
-------- -----------------------
现在 2010-08-31 17:20:57.950
下一秒 2010-08-31 17:20:58.950
下一分 2010-08-31 17:21:57.950
下一小时 2010-08-31 18:20:57.950
明天 2010-09-01 17:20:57.950
下周 2010-09-07 17:20:57.950
下月 2010-09-30 17:20:57.950
下季度 2010-11-30 17:20:57.950
明年 2011-08-31 17:20:57.950
(9 行受影响)
SELECT '下月' AS [日期], DATEADD(mm, 1, GETDATE() ) AS [数据]