sqlServer 日期比较

比较2个日期差小于1分钟。日期格式为yyyy-MM-dd HH:mm:ss

---

SQL code:
DATEDIFF(MS,TIME1,TIME2)<1

---

select ID from FBaoMingXinXi where DATEDIFF(MS,DengJiShiJian,2009-11-16 10:59:50) <1

10 附近语法错误

---

SQL code:
select ID from FBaoMingXinXi where DATEDIFF(MS,DengJiShiJian,'2009-11-16 10:59:50') <1

---

SQL code:
select ID from FBaoMingXinXi where DATEDIFF(MS,DengJiShiJian,'2009-11-16 10:59:50') <1


''日期引号都不打个?

---

如果前后大小不一定的话加绝对值
SQL code:
select ID from FBaoMingXinXi where ABS(DATEDIFF(MS,DengJiShiJian,'2009-11-16 10:59:50')) <1

---

呵呵，是MM，不是MS

---

引用

SQL codeDATEDIFF(MS,TIME1,TIME2) <1

呵呵。。。。

---

呵呵,学习zhong ...