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

20 votes152 views5 answers
Reset auto increment mysql
SQL
5 votes151 views6 answers
In operator sql
SQL
4 votes138 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote150 views1 answer
Hex string sql becomes int64
SQL
0 vote172 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote170 views1 answer
C# sql transaction multiple connections
SQL
2 votes151 views1 answer
Add new column not null sql server
SQL
12 votes135 views4 answers
Mysql ifnull
SQL
3 votes146 views1 answer
Sql cast to integer
SQL
14 votes141 views3 answers
Sql trim from string
SQL