34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT CONVERT(VARCHAR(6), DATEADD(MONTH, 1, CAST('201912' + '01' AS DATE)), 112);
SELECT
CAST(DATENAME(YEAR, DATEADD(MM, 1, CONVERT(DATETIME, LEFT(201912,4) + '-' + RIGHT(201912, 2) + '-01', 120))) AS VARCHAR) +
CAST(DATENAME(MONTH,DATEADD(MM, 1, CONVERT(DATETIME, LEFT(201912,4) + '-' + RIGHT(201912, 2) + '-01', 120))) AS VARCHAR)