-->本年:
select dateadd(dd,number,datename(yy,getdate())+'0101')
from master..spt_values
where type='p'
and number<=datediff(dd,datename(yy,getdate())+'0101',datename(yy,getdate())+'1231')
-->本月:
select dateadd(dd,number,datename(yy,getdate())+datename(mm,getdate())+'01')
from master..spt_values
where type='p'
and number<day(dateadd(mm,1,getdate())-day(getdate()))
SQL语句获得本年日期数据与本月日期数据
最新推荐文章于 2021-12-24 16:13:51 发布