select * from 表 WHERE 1=1 and convert(varchar(100),SC001_APPLYTIME,23) >= ‘2014-08-27‘ and convert(varchar(100),SC001_APPLYTIME ,23)<= ‘2014-08-28‘
convert(varchar(100),SC001_APPLYTIME,23)
去掉时分秒，按日期查询
原文：http://www.cnblogs.com/szxlh/p/3953703.html
