oracle sysdate

Solutions on MaxInterview for oracle sysdate by the best coders in the world

Search
showing results for - "oracle sysdate"
Noah
02 Oct 2018
1SELECT sysdate - 1 FROM dual; 				-- Yesterday    12/01/2021 14:27:27
2SELECT trunc(sysdate) - 1 FROM dual; 		-- Yesterday    12/01/2021 00:00:00
3SELECT sysdate + INTERVAL '20' DAY FROM DUAL;		-- 20 days ahead (other way)
4SELECT sysdate - 1 / 24 FROM dual;					-- 1 hour ago
5SELECT sysdate - 1 / 24 / 60 FROM dual;				-- 1 minute ago
6SELECT add_months(trunc(sysdate), -1) FROM dual;   	-- 1 month ago (no time)
7SELECT trunc(sysdate) - 30 FROM dual;				-- 30 days ago (no time)
8SELECT add_months(trunc(sysdate), -12*2) FROM dual;	-- 2 years ago (no time)
9
10-- ⇓ Test it ⇓ (Fiddle source link)
similar questions
oracle date summer timeto date oracledate format in oracleoracle set date formatoracle sql updateoracle extract year from current dateoracle to dateoracle casetodate oracleoracle default date formatpl sql trigger update sysdateoracle current date without timeto date oracle with timehow to get previous year from sysdate in oracleoracle current sequence valueoracle add months to sysdatechange date format in oracle queryupdate table syntax in oraclesysdate in sqloracle current dateoracle update withcurrent year sql oracleupdate oraclespecific date format oracleupdate from select oracleoracle session date format
queries leading to this page
sysdate 1 oraclesysdate oracleyear from sysdate in oracleoracle sql sysdate as dateoracle sysdate 1 yearoracle sysdate 1oracle sysdate 1 monthoracle sysdatehow to query sysdate in oracle in where clausesysdate in oraclehow to query sysdate in oracleoracle when sysdate month 3e this year all monthsql oracle sysdatewhere sysdate oraclesysdate in oracle sqloracle select sysdateoracle add month to sysdateoracle sysdate formatview sysdate in oracleoracle format sysdateoracle sysdate 1 dayoracle sysdate 6 monthsset sysdate format in oracleoracle sysdate