SQL query, additional post.

-- 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;

Related Posts