CREATE FUNCTION FUN_DAYS(@Year varchar(4),@Month varchar(2)) RETURNS TABLE AS return select top 100 percent @year+'-'+@Month+'-'+rtrim(langid+1) 日期 from master.dbo.syslanguages where langid+1<=day(dateadd(dd,-1,dateadd(mm,1,@Year+'-'+@Month+'-1'))) order by langid
SQL计算给定月天数
最新推荐文章于 2024-02-23 16:39:55 发布