System Date
SELECT sysdate FROM dual;
SELECT sysdate FROM dual;
Subtract 1 Month
SELECT add_months(sysdate,-1) FROM dual
SELECT add_months(sysdate,-1) FROM dual
Add Day, Hour, Minute and Second
SELECT sysdate, sysdate+1, sysdate+1/24, sysdate +1/1440, sysdate + 1/86400 FROM dual;
SELECT sysdate, sysdate+1, sysdate+1/24, sysdate +1/1440, sysdate + 1/86400 FROM dual;
Date Range Selection
SELECT * FROM some_table
WHERE TRUNC(date_created)
BETWEEN TO_DATE('01/20/2001','MM/DD/YYYY')
AND TO_DATE('02/20/2001','MM/DD/YYYY')
;
SELECT * FROM some_table
WHERE TRUNC(date_created)
BETWEEN TO_DATE('01/20/2001','MM/DD/YYYY')
AND TO_DATE('02/20/2001','MM/DD/YYYY')
;