日期:2014-05-18  浏览次数:20543 次

解析日期问题,在线急等
我想把一个日期如:2007-07-31解析出这一天是7月的第几个周,是这个季度的第几个周
怎么做啊,

------解决方案--------------------

select top 366 id=identity(int,0,1)into # from syscolumns
select id,dateadd(day,id, '2007-01-01 ') r,month(dateadd(day,id, '2007-01-01 ')) m,
datepart(week,dateadd(day,id, '2007-01-01 ')) w,
datepart(q,dateadd(day,id, '2007-01-01 ')) q into #t
from # where year(dateadd(day,id, '2007-01-01 '))=2007

select count(distinct w) 季周
from #t
where q=datepart(q, '2007-07-31 ') and datediff(day,r, '2007-07-31 ')> =0

select count(distinct w) 月周
from #t
where m=month( '2007-07-31 ') and datediff(day,r, '2007-07-31 ')> =0
drop table #,#t