我有两个疑问
查询 #1 有效：
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
但是我想在 07:00:00 到 15:00:00 之间查询
请帮忙
谢谢
你可以这样做
convert(varchar(8),convert(time,A.TimeStamp)) between '07:00:00' and '15:00:00'
而不是这个
DATEPART(HOUR,DATEADD(DAY,1,A.TimeStamp)) between 7 and 15
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句