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

1 vote111 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
4 votes104 views1 answer
Mysql ip address
SQL
0 vote110 views1 answer
Mysql trim characters
SQL
0 vote114 views1 answer
Import excel to sql
SQL
6 votes105 views1 answer
Oracle trigger after connect
SQL
0 vote69 views1 answer
Plsql trigger insert update
SQL
1 vote183 views1 answer
Oracle create program if not exists
SQL
4 votes110 views1 answer
Phone number sql
SQL
0 vote141 views1 answer
Eliminate zero from integer mysql
SQL
0 vote114 views1 answer
Every Derived yable must have its own alias
SQL