When I run below query:
select trunc(create_date), count(*) as num_created
from mytable WHERE create_date >= (sysdate -9)
group by trunc(create_date) order by 1;
The output:
06-MAR-24 7
07-MAR-24 1826
08-MAR-24 1135
09-MAR-24 1253
10-MAR-24 1119
11-MAR-24 1446
12-MAR-24 1400
13-MAR-24 2498
14-MAR-24 1633
15-MAR-24 616
And when I run below query:
select trunc(create_date), count(*) as num_created
from mytable WHERE create_date >= (sysdate -10)
group by trunc(create_date) order by 1;
The output:
05-MAR-24 165
06-MAR-24 1020
07-MAR-24 1826
08-MAR-24 1135
09-MAR-24 1253
10-MAR-24 1119
11-MAR-24 1446
12-MAR-24 1400
13-MAR-24 2498
14-MAR-24 1633
15-MAR-24 616
Wondering why the count for 06 March becomes 1020 from 7. (and so on) What I am missing here or doing wrong?