我需要根据时间把重量求和，但是这个时间没办法搞定，时间换成另一种格式，还是不行

Question

select (CONVERT(char(10), a.OperateDt,120)) as OperateDt,a.FurnaceNoVch,sum(a.WeightDbl) as WeightDbl,a.WorkShopVch,a.TOGNameVch,a.MasterNameVch,
(select sum(WeightDbl) from YBinBoxMain where MasterCodeVch='01' and OperateDt= a.OperateDt) as newWeightDblduo,
(select sum(WeightDbl) from YBinBoxMain where MasterCodeVch='24' and OperateDt= a.OperateDt) as newWeightDbltan,
(select sum(WeightDbl) from YBinBoxMain where MasterCodeVch='09' and OperateDt= a.OperateDt) as newWeightDblyi,
(select sum(WeightDbl) from YBinBoxMain where MasterCodeVch='02' and OperateDt= a.OperateDt) as newWeightDblcai,
(select sum(WeightDbl) from YBinBoxMain where TypeCodeVch='09' and OperateDt= a.OperateDt) as newWeightDblyicai,
(select sum(WeightDbl) from YBinBoxMain where MasterCodeVch='03' and OperateDt= a.OperateDt) as newWeightDbltantou,
(select sum(WeightDbl) from YBinBoxMain where MasterCodeVch='11' and OperateDt= a.OperateDt) as newWeightDblfen,
(select sum(WeightDbl) from YBinBoxMain where TypeCodeVch='01' and OperateDt= a.OperateDt) as newWeightDblmian
from View_YBinBoxMain as a
group by (CONVERT(char(10), a.OperateDt,120)), a.FurnaceNoVch,a.WorkShopVch,a.TOGNameVch,a.MasterNameVch,a.OperateDt
order by OperateDt,FurnaceNoVch desc

Answer 1