Question

SQL查询时间范围语句

SQL里
查询SELECT A,B,C,D字段 FROM XY表 where
（id=27 or id=28）and 时间WRITETIME 在2009-01-26到2009-02-06的每天的08：00：00 到 12：30：00之剑

怎么写·

Answer 1

以下为MS_SQL的写法分日期和小时条件;

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'

Answer 2

sql数据库
SELECT A,B,C,D字段 FROM XY表 where（id=27 or id=28）and 时间WRITETIME BETWEEN '2009-1-26' AND '2009-02-06' and 时间WRITETIME BETWEEN '08：00：00' AND ‘12：30：00’

Answer 3

and WRITETIME>'2009-01-26' and WRITETIME>'2009-02-06'

Answer 4

SELECT A,B,C,D FROM XY where (id=27 or id=28) and WRITETIME between '2009-01-26' and dateadd(dd,1,'2009-02-06') and convert(varchar(8),WRITETIME,108) between '08:00:00' and '12:30:00'