摘要:
一天 select * from T_news where datediff(day,addtime,getdate())=0三天select * from T_news where datediff(day,addtime,getdate())<= 2 and datediff(day,addtime,getdate())>= 0一周 select * from T_news WHE... 阅读全文
posted @ 2010-10-25 10:51
tangself
阅读(300)
评论(0)
推荐(0)
摘要:
DateDiff DateDiff: SQL server函数 返回 Variant (Long) 的值,表示两个指定日期间的时间间隔数目。 语法 DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) DateDiff 函数语法中有下列命名参数: 部分 描述 interval 必要。字符串表达... 阅读全文
posted @ 2010-10-25 10:26
tangself
阅读(324)
评论(0)
推荐(0)