* 入参区分 :groupType 1 日、2 周、3 月
* sql :
SELECT
COALESCE(ROUND(CAST ( sum(汇总字段) AS NUMERIC ) , 0),0) "XXX",
<if test="groupType == 1">
to_char( (日期字段)::TIMESTAMP, 'yyyy年mm月dd日') AS "dateStr"
</if>
<if test="groupType == 2">
to_char( (日期字段)::TIMESTAMP, 'yyyy年第ww周' ) AS "dateStr"
</if>
<if test="groupType == 3">
to_char( (日期字段)::TIMESTAMP, 'yyyy年mm月' ) AS "dateStr"
</if>
FROM
表名
WHERE
条件
GROUP BY
"dateStr"