Oracle current date plus 1 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

0 vote374 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
19 votes339 views6 answers
Sql server drop table if exists
SQL
17 votes398 views4 answers
Show all tables in oracle
SQL
0 vote280 views1 answer
Import sql file in mysql linux
SQL
0 vote438 views1 answer
Delet all record statment sql
SQL
1 vote327 views1 answer
Stop mysql server mac
SQL
0 vote331 views1 answer
Display first three characters sql
SQL
2 votes352 views2 answers
How to create an empty table from an existing table
SQL
0 vote330 views1 answer
Postgres declare variable
SQL
0 vote374 views1 answer
Space not removing from column in sql
SQL