--16-12-2015 12:33:21 SELECT SYSDATE FROM dual; --16-12-2015 SELECT trunc(SYSDATE) FROM dual; --16-12-2015 SELECT to_date(SYSDATE) AS ToDate FROM dual; --16-12-2015 SELECT to_date(SYSDATE, 'DD-MM-YY') AS ToDate FROM dual; --16-12-2015 SELECT to_char(SYSDATE, 'DD-MM-YYYY') AS ToDate FROM dual;