常用的获取时间差的sql语句
摘要:
本文章来自博客园:http://www.cnblogs.com/cyjch/archive/2012/02/06/2340216.html为了以后方便使用,插个旗;常用的获取时间差的sql语句"select count(*) from [注册] where datediff(day,time,getdate())=dateadd(day,2-datepart(weekday,getdate()),convert(varchar,getdate(),112)) and create_day=dateadd(day,-5-datepart(weekday,getdate()),conve 阅读全文
posted @ 2013-07-03 14:53 _小宋 阅读(1086) 评论(0) 推荐(0) 编辑