select * from dd_fare_putout where day between '2001-12-12' and '2003-1-1' 或 select * from dd_fare_putout where convert(char(10),day,120) between '2001-12-12' and '2003-1-1'
select * from dd_fare_putout where day between '2001-12-12' and '2003-1-1' or select * from dd_fare_putout where day >= '2001-12-12' and day <= '2003-1-1'
或
select * from dd_fare_putout where convert(char(10),day,120) between '2001-12-12' and '2003-1-1'
or
select * from dd_fare_putout where day >= '2001-12-12' and day <= '2003-1-1'
不过,前一位已经把问题搞定,
我把贴结先了,
还是得很感谢!