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 vote216 views1 answer
Tsql get beginning of year
SQL
0 vote210 views1 answer
Why we have to set the password for my sql server
SQL
0 vote264 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote207 views1 answer
Oracle synonym procedure dblink
SQL
3 votes211 views2 answers
Sql select data from last week
SQL
1 vote200 views1 answer
Input in mysql
SQL
9 votes196 views1 answer
Identity insert on sql server
SQL
0 vote203 views1 answer
Sql put two columns into one
SQL
0 vote218 views1 answer
Update sql sintax
SQL
2 votes211 views2 answers
Enable foreign key checks postgres
SQL