--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;