-- Plus year to the last day of the month
SELECT add_months(LAST_DAY(SYSDATE),12) AS NextYearDate FROM dual;
-- Plus 5 min
SELECT sysdate + 5/(24*60) FROM dual;
SELECT sysdate, sysdate + INTERVAL '5' MINUTE FROM dual;
-- Plus 1 min
SELECT sysdate - 1/(24*60) FROM dual;
-- Minus 1 hour
SELECT sysdate - 60/(24*60) FROM dual;
-- Minus 1 day
SELECT sysdate - 1 FROM dual;
-- Minus 1 month
SELECT add_months(sysdate, -1) FROM dual;
-- Minus 1 year
SELECT EXTRACT(YEAR FROM sysdate) - 1 FROM dual; |
-- Plus year to the last day of the month
SELECT add_months(LAST_DAY(SYSDATE),12) as NextYearDate from dual;
-- Plus 5 min
select sysdate + 5/(24*60) from dual;
select sysdate, sysdate + interval '5' minute from dual;
-- Plus 1 min
select sysdate - 1/(24*60) from dual;
-- Minus 1 hour
select sysdate - 60/(24*60) from dual;
-- Minus 1 day
select sysdate - 1 from dual;
-- Minus 1 month
select add_months(sysdate, -1) from dual;
-- Minus 1 year
select extract(year from sysdate) - 1 from dual;