SQL - Date get ' first day month-1 / last day month-1 / first day current month '

From GUILLARD WIKI
Revision as of 10:25, 18 May 2018 by Guillard (talk | contribs) (Created page with "<syntaxhighlight lang="sql"> select ADD_MONTHS(LAST_DAY(SYSDATE),-2)+1 "FIRST DAY, MONTH-1", LAST_DAY(ADD_MONTHS(SYSDATE,-1)) "LAST DAY MONTH-1", ADD_MONTHS(LAST_DAY(...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
select 
  ADD_MONTHS(LAST_DAY(SYSDATE),-2)+1 "FIRST DAY, MONTH-1", 
  LAST_DAY(ADD_MONTHS(SYSDATE,-1)) "LAST DAY MONTH-1",
  ADD_MONTHS(LAST_DAY(SYSDATE),-1)+1 "FIRST DAY CURRENT MONTH"
from dual;