Oracle sysdate

SELECT sysdate - 1 FROM dual; 				-- Yesterday    12/01/2021 14:27:27
SELECT trunc(sysdate) - 1 FROM dual; 		-- Yesterday    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 ago
SELECT sysdate - 1 / 24 / 60 FROM dual;				-- 1 minute ago
SELECT add_months(trunc(sysdate), -1) FROM dual;   	-- 1 month ago (no time)
SELECT trunc(sysdate) - 30 FROM dual;				-- 30 days ago (no time)
SELECT add_months(trunc(sysdate), -12*2) FROM dual;	-- 2 years ago (no time)

-- ⇓ Test it ⇓ (Fiddle source link)

Source: sqlfiddle.com

Similar codes

1 vote318 views1 answer
Mysql best tutorial for beginners
SQL
0 vote268 views1 answer
Import sql file in mysql linux
SQL
0 vote342 views1 answer
Drop domain postgresql
SQL
1 vote307 views1 answer
Sql group by error
SQL
0 vote324 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
12 votes355 views6 answers
How to install sqlite3 in python
SQL
20 votes330 views1 answer
Sql change column types
SQL
0 vote316 views2 answers
Mysql add days to date
SQL
0 vote312 views1 answer
Mysql into outfile with headers
SQL
2 votes332 views2 answers
Sql percentage
SQL