If you want to show or if you need the month first day, last time I check there was no built-in function in Oracle. But you can get it easily by using some other single-row date function. Here bellow an example of this.
SELECT LAST_DAY(ADD_MONTHS(SYSDATE,-1))+1
FROM DUAL;
Run the above sql and you will get the first day of current month.
For last day of current month just use the LAST_DAY function like this LAST_DAY(SYSDATE)
Need more help ? Just Leave you comments…
*********************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
well.
*********************************************************************************************************************