取年数,月数 DECLARE @Year int--年份DECLARE @Month int--月份--年份SET @Year = DATEPART(Year,@p2)SET @Year = YEAR(@p2)--月份SET @Month = DATEPART(Month,@p2)SET @Month = Month(@p2)