Oracle add month

SELECT sysdate + 1 FROM dual; 				-- Tomorrow    12/01/2021 14:27:27
SELECT trunc(sysdate) + 1 FROM dual; 		-- Tomorrow    12/01/2021 00:00:00
SELECT sysdate + INTERVAL '20' DAY FROM DUAL;		-- 20 days ahead (other way)
SELECT sysdate + 1 / 24 FROM dual;					-- 1 hour ahead
SELECT sysdate + 1 / 24 / 60 FROM dual;				-- 1 minute ahead
SELECT add_months(trunc(sysdate), 1) FROM dual;   	-- 1 month ahead (no time)
SELECT trunc(sysdate) + 30 FROM dual;				-- 30 days ahead (no time)
SELECT add_months(trunc(sysdate), +12*2) FROM dual;	-- 2 years ahead (no time)

Similar codes

3 votes175 views1 answer
Sql timestamp to date
SQL
2 votes192 views1 answer
Convert series number to date in sql
SQL
0 vote253 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote183 views2 answers
Insert into
SQL
0 vote192 views1 answer
Sql developer search all packages for text
SQL
1 vote256 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote239 views1 answer
Update database collation in postgresql
SQL
1 vote197 views3 answers
Reset sql primary key
SQL
1 vote227 views1 answer
Does insert into overwrite sql
SQL
0 vote203 views1 answer
If null don't update
SQL