SQL比较时间查询语句

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‘;

SQL比较时间查询语句

标签：table   sql   datetime   div   oom   highlight   通过   pre   style