SELECT
FFactoryCode,
sum( FPartialOpen ) AS sum_FPartialOpen,
convert(nvarchar(10),fdate,120)
FROM
MY_SP_GradeAndWeight
WHERE
FDelete = 0
and FFactoryCode=103
GROUP BY
FFactoryCode,
convert(nvarchar(10),fdate,120)
ORDER BY convert(nvarchar(10),fdate,120) desc;
总结:convert(nvarchar(10),fdate,120) ,截取时间格式(年月日)