如上如只需要强转一下即可:
SELECT
requesttime::timestamp with time zone AS "time",
requestresult AS metric,
count(requestresult) AS "requestresult"
FROM sdf
GROUP BY 1,2
ORDER BY 1,2
如上如只需要强转一下即可:
SELECT
requesttime::timestamp with time zone AS "time",
requestresult AS metric,
count(requestresult) AS "requestresult"
FROM sdf
GROUP BY 1,2
ORDER BY 1,2