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 vote635 views1 answer
Sql show table name in result
SQL
2 votes137 views1 answer
Pdo mysql insert
SQL
0 vote137 views1 answer
Mysql procedure between two tables
SQL
0 vote123 views1 answer
Mysql update sequence with order by
SQL
5 votes129 views1 answer
Oracle ORA-00054 origin
SQL
0 vote134 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote141 views1 answer
Check if database exists sql
SQL
0 vote151 views1 answer
Count database access django
SQL
3 votes121 views2 answers
How to start mysql in terminal
SQL
7 votes143 views1 answer
Query delete duplicates
SQL