Showing posts with label timestamp. Show all posts
Showing posts with label timestamp. Show all posts
Friday, April 1, 2016
sql for first day of month and last day of month
select SYSDATE ,
last_day(sysdate) as LAST_DATE_CURR_MNTH,
ADD_MONTHS(last_day(sysdate),-1) as PREVIOUS_MON_LAST_DATE,
last_day(sysdate)+1 as NEXT_MON_FIRST_DATE,
ADD_MONTHS(last_day(sysdate),+1) as NEXT_MON_LAST_DATE,
ADD_MONTHS(last_day(sysdate),+5) as LAST_DATE_OF_5TH_MON,
ADD_MONTHS(last_day(sysdate),+5) +1 as FIRST_DATE_IN_6TH_MON_AFTR_NOW
from dual;
"SYSDATE" "LAST_DATE_CURR_MNTH" "PREVIOUS_MON_LAST_DATE" "NEXT_MON_FIRST_DATE" "NEXT_MON_LAST_DATE" "LAST_DATE_OF_5TH_MON"
----------- --------------------- ------------------------ --------------------- -------------------- -----------------------
"FIRST_DATE_IN_6TH_MON_AFTR_NOW"
-----------------------
01-APR-16 30-APR-16 31-MAR-16 01-MAY-16 31-MAY-16 30-SEP-16
-----------------------
01-OCT-16
Subscribe to:
Posts
(
Atom
)