ORACLE 数据库如何 统计每小时数据量 时间字段 DATE
/*ORACLE 数据库 统计每小时数据量 时间字段 DATE*/
SELECT LEFT
(FROM_UNIXTIME( TIME ), 13 ) AS DT,
COUNT( * ) AS DATACOUNT
FROM
表名
WHERE
ISSUCCESS = 1
AND TIME > UNIX_TIMESTAMP( "2019-05-08 00:00:00" )
GROUP BY
LEFT ( FROM_UNIXTIME( TIME ), 13 )
ORDER BY
DT DESC;