SELECT * FROM TabName WHERE inteventid=1 AND CONVERT(VARCHAR(8),vchrOccurEventBeginTime,108) BETWEEN '08:00:00' AND '09:00:00'
SELECT * FROM TabName WHERE inteventid=1 AND CONVERT(VARCHAR(8),vchrOccurEventBeginTime,108) BETWEEN '08:00:00' AND '09:00:00' 这个查询出来是空值哈 我就是想看看 就是 vchrOccurEventBeginTime 这个字段 因为前面还有日期,怎么写才能不看日期,只看时间来筛选结果
查8到10点数据这样用09:59:59 SELECT * FROM TabName WHERE inteventid=1 AND CONVERT(VARCHAR(8),vchrOccurEventBeginTime,8) BETWEEN '08:00:00' AND '09:59:59'
这个查询出来是空值哈 我就是想看看 就是 vchrOccurEventBeginTime 这个字段 因为前面还有日期,怎么写才能不看日期,只看时间来筛选结果
SELECT * FROM TabName WHERE inteventid=1 AND CONVERT(VARCHAR(8),vchrOccurEventBeginTime,8) BETWEEN '08:00:00' AND '09:59:59'