Oracle autotrace - pstart and pstop always the same
Sure it should, given that you wrote proper SQL. But you used a derived value in the filter conditions instead of the actual column.
Actual condition in SQL should be something like this (I also changed the date format string and the values to make some sense):
where event_time between BETWEEN TO_DATE('06-JUL-2020', 'dd-MON-yyyy')
AND TO_DATE('07-JUL-2020', 'dd-MON-yyyy')