declare @stime datetime
declare @etime datetime
set @stime = '2018-11-13 00:00:00';
set @etime = '2018-11-13 23:59:59';
select * from a where create_time>=@stime and create_time<=@etime
declare @stime datetime
declare @etime datetime
set @stime = '2018-11-13 00:00:00';
set @etime = '2018-11-13 23:59:59';
select * from a where create_time>=@stime and create_time<=@etime