Question

如何查询2011-1-1 9：30到10：00 至2011-5-7 9：30到10：00 之间的数据，怎么写SQL

Answer 1

我猜你是这个意思
select ... from ....
where datetime between to_date('2011-01-01 09:30:00','yyyy-mm-dd hh24:mi:ss') and to_date('2011-01-01 10:00:00','yyyy-mm-dd hh24:mi:ss')
or
datetime between to_date('2011-05-07 09:30:00','yyyy-mm-dd hh24:mi:ss') and to_date('2011-05-07 10:00:00','yyyy-mm-dd hh24:mi:ss')

Answer 2

sql server
假设 字段为‘时间’
where ((datepart(hh,时间) = 9
and datepart(mi,时间) >= 30
and datepart(mi,时间) <=59)
or (datepart(hh,时间) = 10 and datepart(mi,时间)=0))
and 时间 >='2011-1-1 9:30'
and 时间 <='2011-5-7 10:00'

Answer 3

SELECT *
FROM 数据表
WHERE 时间 BETWEEN '2011-1-1' AND '2011-5-7'
AND DatePart(hh, 时间) <= 10
AND ((DatePart(hh, 时间) = 9 AND DatePart(mi, 时间) >= 30) OR (DatePart(hh, 时间) > 9) )