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

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

Jump to navigation Jump to search

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: Users.

You can view and copy the source of this page.

<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(SYSDATE),-1)+1 "FIRST DAY CURRENT MONTH"
from dual;

</syntaxhighlight>

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

Retrieved from "http://thomasguillard.fr/wiki/index.php?title=SQL_-_Date_get_%27_first_day_month-1_/_last_day_month-1_/_first_day_current_month_%27"

Navigation menu