将varchar值'7:00'转换为数据类型int转换失败int

Question

我无法计算如何转换此时间。我看到了如何转换其他值但不是时间的其他方法。谁能帮助谢谢。

select count(*) 
from reporting_call_matrix AS A WITH (NOLOCK) 
Where CALENDAR_DATE Between '10/1/2015' and '10/31/2016' and Call_hour Between '7:00' and '19:00' 

Answer 1

根据错误消息，call_hour将显示为整数。所以，试试这个：

select count(*) 
from reporting_call_matrix AS A WITH (NOLOCK) 
Where CALENDAR_DATE Between '2015-10-01' and '2016-10-31' and 
     Call_hour Between 7 and 19; 

我强烈建议你为日期常量使用ISO标准日期格式。