表test
字段1,id int 标识
字段2,name varchar(10) 列车名
字段3,time datetime 日期
查询日期为2017年5月6日的列车信息
select * from test where to_date(time,'yyyy-MM-dd')='2017-05-06'
select * from test where datediff(DAY,字段3,'2017-05-06')=0
select * from test where 字段3='2017-05-06'
SELECT * FROM test WHERE time='2017-05-06';
select * from tase where 字段三='日期'
select * from test where try_cast(time as date)='2017-05-06';
SELECT * FROM test WHERE 字段3=‘2017-05-06’