SQL查询限定时间语句

[HWorld]

现有一数据库，表（T1）里有一字段startrecordtime，时间格式示例：2008-04-14 09:51:01.000，datetime类型。我现在要查询2008-04-14至2008-04-16这两天08：00到18：00的数据，该怎么查询呢？

[中国风]

SELECT  *
FROM    T1
WHERE   CONVERT(VARCHAR(10), startrecordtim, 120) BETWEEN '2008-04-14'
                                                  AND     '2008-04-16'
AND CONVERT(VARCHAR(5),startrecordtim,5) BETWEEN '08:00' AND '18:00'

[还在加载中灬]

WHERE startrecordtime BETWEEN'2008-04-14'AND'2008-04-16'
AND CONVERT(VARCHAR(8),startrecordtime,8) BETWEEN'08:00:00'AND'18:00:00'

[竹笋包子]

select * from T1 where startrecordtime between '2008-04-14'and '2008-04-15'and convert (VARCHAR(9),startrecordtime,9)between '08:00'and'18:00'--CONVERT() 函数是把日期转换为新数据类型的通用函数;CONVERT() 函数可以用不同的格式显示日期/时间数据。

[中国风]

引用 1 楼 roy_88 的回复:

SELECT  *
FROM    T1
WHERE   CONVERT(VARCHAR(10), startrecordtim, 120) BETWEEN '2008-04-14'
                                                  AND     '2008-04-16'
AND CONVERT(VARCHAR(5),startrecordtim,5) BETWEEN '08:00' AND '18:00'

手误日期格式ID输错 CONVERT(VARCHAR(5),startrecordtim,8) BETWEEN '08:00' AND '18:00'

[runnersun]

oracle有相关日期函数 select * from up_date where update between to_date('2007-07-07 00:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('2007-09-07 00:00:00','yyyy-mm-dd hh24:mi:ss')