按天统计每日记录数
一、oracle按天统计每天的记录数SELECT TRUNC(lastUpdateTime) AS 统计日期, COUNT(*) AS 当日记录数 FROM interface.xxx where lastUpdateTime TO_TIMESTAMP(2025-10-01 00:00:00, YYYY-MM-DD HH24:MI:SS) and lastUpdateTime TO_TIMESTAMP(2025-10-31 23:59:59, YYYY-MM-DD HH24:MI:SS) GROUP BY TRUNC(lastUpdateTime) ORDER BY TRUNC(lastUpdateTime);二、pg按天统计每天的记录数SELECT lastUpdateTime::date AS 统计日期, COUNT(*) AS 当日记录数 FROM inp.public.病区入院记录 WHERE lastUpdateTime TIMESTAMP 2026-09-20 00:00:00 AND lastUpdateTime TIMESTAMP 2026-10-03 23:59:59 GROUP BY lastUpdateTime::date ORDER BY lastUpdateTime::date desc;