Date function : system date

Oracle

SELECT CURRENT_DATE FROM DUAL;
SELECT SYSDATE FROM DUAL;

Oracle Date Functions : http://psoug.org/reference/date_func.html