First Day of Current Month
1 | SELECT trunc(sysdate) - (to_number(to_char(sysdate,'DD')) - 1) FROM dual |
Last Day of Current Month
1 | SELECT add_months(trunc(sysdate) - (to_number(to_char(sysdate,'DD')) - 1), 1) -1 FROM dual |
1 | SELECT trunc(sysdate) - (to_number(to_char(sysdate,'DD')) - 1) FROM dual |
1 | SELECT add_months(trunc(sysdate) - (to_number(to_char(sysdate,'DD')) - 1), 1) -1 FROM dual |
8 Comments on “First and Last Day of Month – Oracle SQL Syntax Examples”
Thank you 🙂
You can use LAST_DAY function to be more simpler way:
select last_day(sysdate) from dual;
In “Last Day of Current Month” having four functions. Is any performance issue using this???
First day of current month:-
SELECT SYSDATE,ADD_MONTHS((LAST_DAY(SYSDATE)+1),-1) FROM DUAL;
first day can be fetched using this too: trunc((sysdate),’month’)
for next month 1 st day
Select last_day(sysdate)+1 from dual.
how to extract month start date and month end date for a 4-4-5 calender
Pingback: First and Last Day of Month – Oracle SQL Syntax Examples | Chris Memo