sql 时间段查询

select * from 表名 where convert(char(10),要查询的字段名,120)>= '2012-04-26' and convert(char(10),要查询的字段名,120)<='2012-05-13'