SELECT MAX(t1.todaymaxvol) todaymaxvol,towernumber FROM (SELECT CONVERT(decimal(20,2), LTrim(RTrim(volume))) todaymaxvol , towernumber FROM catch_gas (nolock) WHERE 1=1 and CONVERT(varchar(100), time,20)>='2019-01-01 20:30:59' AND CONVERT(varchar(100), time, 20) <='2019-02-01 08:30:59' AND towernumber <>'140807101810(二期)') t1 GROUP BY towernumber运行红色部门就不报错 ,整体运行就报错 从数据类型 nvarchar 转换为 numeric 时出错,应该是条件中日期的比较那边出问题了,但是不知道怎么解决…………