sql servel 报错:将 expression 转换为数据类型 int 时出现算术溢出错误。
执行sql语句:SELECT AVG( DATEDIFF(s,s.CreatedDate,s.SendDate) ) AS submitTime
FROM dbo.SmsSend AS s WHERE s.CreatedDate BETWEEN '2017-08-01' AND '2017-08-31'
报错信息:将 expression 转换为数据类型 int 时出现算术溢出错误。
警告: 聚合或其他 SET 操作消除了 Null 值。
这是因为数据值太大了,导致报错,解决方案:
SELECT AVG( CONVERT(bigint, DATEDIFF(s,s.CreatedDate,s.SendDate) ) ) AS submitTime
FROM dbo.SmsSend AS s
欢迎关注公众号:DotNet软件编程IT技术
欢迎关注公众号:DotNet软件编程IT技术