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