📅 Date Functions
ADD_MONTHS, TRUNC, LAST_DAY: date math that Oracle makes easy.
| Snippet | |
|---|---|
| ☆ADD_MONTHS — Shift a date by whole months |
SELECT ADD_MONTHS(SYSDATE, 6) FROM dual;
|
| ☆TRUNC (YEAR) — Round a date down to a boundary |
SELECT TRUNC(SYSDATE, 'YEAR') FROM dual;
|
| ☆LAST_DAY — Last day of the current month |
SELECT LAST_DAY(SYSDATE) FROM dual;
|