Revision history of "SQL - Date get ' first day month-1 / last day month-1 / first day current month '"

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

  • curprev 10:25, 18 May 2018‎ Guillard talk contribs‎ 246 bytes +246‎ 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(..."
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"