Date and Timestamp SELECT DATE'2014-03-24' FROM DUAL;SELECT TIMESTAMP'2014-03-24 15:13:00' FROM DUAL