摘要: SQL Server 中时间比较例子:select count(*) from table whereDATEDIFF([second], '2004-09-18 00:00:18', '2004-09-18 00:00:19') > 0说明 select DATEDIFF(day, time1 , time2) 对应示例语句如下 select DATEDIFF(day, '2010-07-23 0:41:18', '2010-07-23 23:41:18') time1 >time2 为负数; time1 < 阅读全文
posted @ 2011-07-15 16:00 hen 阅读(66057) 评论(1) 推荐(4) 编辑