mybatis 中使用 >= 是 >=
<=是 <= 如下sql所示
SELECT
SUM (total) AS RECENT_COUNT,
ROUND(AVG(CONGESTION), 0) CONGESTION
FROM
T_TRAFFICPARAMMSG
WHERE
TO_DATE (
SEND_TIME,
'yyyy-mm-dd hh24:mi:ss'
) >= TO_DATE (
#{startTime},
'yyyy-mm-dd hh24:mi:ss'
)
AND TO_DATE (
SEND_TIME,
'yyyy-mm-dd hh24:mi:ss'
) <= TO_DATE (
#{endTime},
'yyyy-mm-dd hh24:mi:ss'
)