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 vote330 views1 answer
Name of today sql
SQL
2 votes371 views1 answer
Find column in all stored procedures sql server
SQL
1 vote324 views1 answer
Get create table query existing table mysql
SQL
0 vote329 views1 answer
SAP Return
SQL
0 vote303 views1 answer
Mysql function variable
SQL
11 votes306 views2 answers
Set default column value sql
SQL
-1 vote299 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote317 views1 answer
Oracle job class
SQL
0 vote320 views1 answer
Order by in codeigniter query builder
SQL
0 vote373 views1 answer
Mssql last day of month
SQL