mysql - 如何在sql中搜索数据时间戳

Question

SELECT * 
FROM dbPLC.dbo.PLC_CPacking3KW2P3 AS A 
INNER JOIN dbPLC.dbo.PLC_CPacking3KW2P3 AS B ON B.NoUrut = A.NoUrut - 1 
WHERE A.Nilai - B.Nilai = 1 
AND CONVERT(DATE, A.TimeStamp) = CONVERT(DATE, '2017/08/13') 
AND DATEPART(HOUR, DATEADD(DAY, 1, A.TimeStamp)) BETWEEN 7 AND 15

我想在 09:00:00 到 10:00:00 之间查询 谢谢您的回复。

标签： mysql

Answer 1

我找到了解决方案。

convert(varchar(8),convert(time,A.TimeStamp)) between '09:00:00' and '10:00:00'