SELECT
COUNT(1)
FROM
rawdata_vehiclepassing x
WHERE
x.passingtime >= to_date('2019-11-24,00:00:00','yyyy-mm-dd,hh24:mi:ss')
AND x.passingtime <= to_date('2019-11-25,00:00:00','yyyy-mm-dd,hh24:mi:ss')
SELECT COUNT(1)
FROM rawdata_vehiclepassing T
where T.passingtime>=to_date('2019-11-24') AND T.passingtime<to_date('2019-11-25')
