try select * from cust_info_back where cust_back_time between '2003-11-24 16:23:40' and '2003-11-24 16:23:40'
select * from cust_info_back where cust_back_time >=cast('2003-11-24 16:23:40' as datetime) and cust_back_time <=cast('2003-11-24 16:23:40' as datetime)
把时间范围放大一点试试: select * from cust_info_back where cust_back_time >='2003-11-24 16:23:40' and cust_back_time <='2003-11-24 16:23:41'
select * from cust_info_back where cust_back_time between '2003-11-24 16:23:40' and '2003-11-24 16:23:41'
select * from cust_info_back where cust_back_time >='2003-11-24 16:23:40.001' and cust_back_time <='2003-11-24 16:23:40.099'
select * from cust_info_back where cust_back_time >=cast('2003-11-24 16:23:40.001' as varchar(19)) and cust_back_time <=cast('2003-11-24 16:23:40.099' as varchar(19))
select * from cust_info_back where convert(varchar(20),cust_back_time,120) ='2003-11-24 16:23:40'
select * from cust_info_back where cust_back_time between '2003-11-24 16:23:40' and '2003-11-24 16:23:40'
as datetime) and
cust_back_time <=cast('2003-11-24 16:23:40' as datetime)
select * from cust_info_back where cust_back_time >='2003-11-24 16:23:40' and
cust_back_time <='2003-11-24 16:23:41'
cust_back_time <='2003-11-24 16:23:40.099'
cust_back_time <=cast('2003-11-24 16:23:40.099' as varchar(19))