select * from xy where (id=27 or id=28) and convert(varchar(10),WRITETIME,120) between '2009-01-26' and '2009-02-06' --日期 and convert(varchar(8),WRITETIME,108) between '08:00:00'and '12:30:00' --时间