SQL比较时间查询语句

 

select * from table1 
where datediff(mm,'2009-8-12 13:17:50', date)>0

　　

select * from table1 
where datediff(ms,'2009-8-12 13:17:50', date)>0

 

select * from table1 where cast(date as datetime)>'2009-8-12 13:17:50'

 

select * from table1 where CONVERT(DATETIME,date)>'2009-8-12 13:17:50' 

 

本人测试这条也能通过:

select * from RoomInfo where CreateTime > '2017/7/3 10:46:33';