Morning All,
the first day of the current month is:
select trunc(sysdate, 'MM') from dual;
01/02/2020
The first of next month is:
select trunc(add_months(sysdate, 1), 'MM') from dual;
01/03/2020
The last day of this month is:
select trunc(add_months(sysdate, 1), 'MM') -1 from dual;
29/02/2020
So, your SQL for between the first of the month and this morning at will be something like:
select ... from ... where some_date_column between trunc(sysdate, 'MM') and trunc(sysdate);
If you want between the first of the month and right this very second, the it will be:
select ... from ... where some_date_column between trunc(sysdate, 'MM') and sysdate;
If you want the first day of this month and the first day of next month:
select ... from ... where some_date_column between trunc(sysdate, 'MM') and trunc(sysdate);
If you want only this month, from the first second to the very last second:
select ... from ... where some_date_column between trunc(sysdate, 'MM') and (trunc(add_months(sysdate, 1), 'mm')) -1/24/60/60;
HTH
Cheers,
Norm. [TeamT]