执行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修炼宝典。 或者扫一下二维码