Test 02

select sysdate from dual;

select add_months(last_day(sysdate),-1)+1 firt_day ,last_day(sysdate) lastday from dual;

select NEXT_DAY(trunc(SYSDATE), ‘&Day’) from dual;

select to_char(SYSDATE,’dd-mm-yy hh:mi:ss’) from dual;

select (last_day(add_months(trunc(SYSDATE),-to_char(trunc(sysdate),’MM’)))+1) first_day ,
last_day(add_months(trunc(SYSDATE),-to_char(trunc(sysdate),’MM’)))+1 last_day
from dual;

select trunc(sysdate) from dual;
select trunc(sysdate,’MON’) First_day_of_month from dual;
select trunc(sysdate,’YEAR’) First_day_of_year from dual;
SELECT TRUNC (SYSDATE , ‘YEAR’) FROM DUAL;

SELECT ADD_MONTHS(TRUNC (SYSDATE , ‘YEAR’),12)-1 FROM DUAL;

select trunc(sysdate,’MON’) from dual;

SELECT ADD_MONTHS (TRUNC (SYSDATE,’YEAR’), -12) FROM DUAL;

SELECT add_months(TRUNC(sysdate,’YYYY’),0) “First Day”,
add_months(TRUNC(sysdate,’YYYY’)-1,12) as Lasst_Day
FROM dual;