摘要: sql常用的星期方法:SELECT convert(varchar(10),DATEADD(wk, DATEDIFF(wk,0,getdate()), 0),120) --本周开始周一SELECT convert(varchar(10),DATEADD(wk, DATEDIFF(wk,5,getda... 阅读全文
posted @ 2014-11-12 09:08 _AfenG 阅读(408) 评论(0) 推荐(0) 编辑