根据参数ny(年月)获取指定年月的天数，该怎么做呢
根据参数ny(年月)获取指定年月的天数，该怎么做呢

[解决办法]

SQL code

declare @ny intset @ny=201206select datepart(dd,dateadd(dd,-1,dateadd(m,1,ltrim(@ny)+'01')))
[解决办法]
SQL code
DECLARE @N VARCHAR(10) = '2012'DECLARE @Y VARCHAR(10) = '06'SELECT CONVERT(VARCHAR(10),DATEADD(DAY,number,@N + '-' + @Y + '-' + '01'),23) AS Date FROM master..spt_values WHERE type = 'P' AND DATEADD(DAY,number,@N + '-' + @Y + '-' + '01') < CONVERT(VARCHAR(8),DATEADD(MONTH,1,@N + '-' + @Y + '-' + '01'),21) + '01' Date2012-06-012012-06-022012-06-032012-06-042012-06-052012-06-062012-06-072012-06-082012-06-092012-06-102012-06-112012-06-122012-06-132012-06-142012-06-152012-06-162012-06-172012-06-182012-06-192012-06-202012-06-212012-06-222012-06-232012-06-242012-06-252012-06-262012-06-272012-06-282012-06-292012-06-30