有大佬能来帮帮忙么

[qq_30125065]

数据库time的属性是datatime 现在的查询语句是
SELECT count(*) FROM `tie` WHERE `time` BETWEEN '2018-10-09 07:00:00' AND '2018-10-09 09:00:59'
但是我表内的数据并不只是10月9日的 是一周7天的数据
而我只需要每天07:00:00到09:00:59 这个时间段的数据 不只是要9号的 是一周的该时间段的数据 这要如何写啊

[吉普赛的歌]

-- sqlserver
SELECT COUNT(*)
FROM   [tie]
WHERE  [time] BETWEEN '2018-10-07' AND '2018-10-14'
AND CONVERT(CHAR(5),[time],14) BETWEEN '07:00' AND '09:00'

-- mysql
SELECT COUNT(*)
FROM   `tie`
WHERE  `time` BETWEEN '2018-10-07' AND '2018-10-14'
AND DATE_FORMAT(FROM_UNIXTIME(`time`),'%H:%i') BETWEEN '07:00' AND '09:00'

最好发一下测试表、测试数据的脚本， 说明数据库类型、版本。

[二月十六]

试试这样

select count(*) from `tie` WHERE  DATE_FORMAT(`time`,'%H:%i:%s') BETWEEN '07:00:00' AND '09:00:59'  and DATE_FORMAT(`time`,'%Y-%m-%d') BETWEEN '2018-10-09' AND '2018-10-16'