SQLserver2000时间计算整理

?select? convert(char(10),dateadd(mm,datediff(mm,getdate()),0),120) as '月初'

select convert(char(10),dateadd(wk,datediff(wk,120) as '本周一'

select convert(char(10),dateadd(qq,datediff(qq,120) as '本季度第一天'

select convert(char(10),dateadd(ms,-3,0)),120)? as '上月最后一天'

select convert(char(10),1,0))),120)? as '本月最后一天1'
select convert(char(10),DATEADD(mm,? DATEDIFF(m,getdate())+1,? 0)),120)? as '本月最后一天2'

select convert(char(10),0)+1),120)? as '下月第一天'

select convert(char(10),DATEADD(wk,? DATEDIFF(wk,dateadd(dd,6-datepart(day,getdate())),120) as '本月第一周'
select? datename(weekday,getdate())? as '今天星期几'

SELECT? case? day(dateadd(mm,? 2,? dateadd(ms,DATEADD(yy,? DATEDIFF(yy,? 0))))? when? 28? then? '平年'? else? '闰年'? end? as '什么年'

declare @m? tinyint,@time? smalldatetime?
select? @m=month(getdate())?
select? @m=case? when? @m? between? 1? and? 3? then? 1?
?????????????????????? when? @m? between? 4? and? 6? then? 4?
?????????????????????? when? @m? between? 7? and? 9? then? 7?
?????????????????????? else? 10? end?
select? @time=datename(year,getdate())+'-'+convert(varchar(10),@m)+'-01'?
select? datediff(day,@time,3,@time))? as? '当前季度多少天'

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/gmj_1019/archive/2006/09/15/1227149.aspx

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!