Oracle current date minus 1 day

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 - 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)

Similar codes

0 vote342 views1 answer
2020 new year
SQL
0 vote344 views1 answer
Postgressql uuid
SQL
1 vote405 views3 answers
Reseed sql table primary key
SQL
0 vote349 views1 answer
How to find database collation in postgres
SQL
5 votes382 views1 answer
Sysdate in oracle sql
SQL
2 votes399 views1 answer
Oracle Column Names of a table
SQL
1 vote385 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
1 vote373 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
1 vote348 views1 answer
Sql list all procedures
SQL
0 vote357 views1 answer
Postgres enumerated type
SQL