Question

我的SQL数据库里有一个字段为datatime（DTIME），我想取两个时间段之间的数据，请问SQL语句怎么写？

并按时间先后排序，高手指教。

Answer 1

select datatime from 表名 where
datatime BETWEEN value1 AND value2 order by datatime desc
其中between and取出两个时间段之间的数据，order by排序，desc倒序（即先后）

Answer 2

select * from table
where datetime>' 2011-02-24' and datetime < '2011-02-25'
order by datetime

取出来的就是24号当天的所有数据。

Answer 3

标准语法 使用between and
select *
from tb
where DTIME BETWEEN 时间起始点 and 时间结束点
order by DTIME;

Answer 4

select * from table
where datetime > cast('2011-02-24 00:00:00'as datetime)
and datetime < cast('2011-02-25 00:00:00'as datetime)

Answer 5

select * from [表名] where DTIME between [时间1] AND [时间2] ORDER BY DTIME