TIMESTAMP_TO_DATE() SQL Function

TIMESTAMP_TO_DATE(timestamp) converts a timestamp containing a value for time to a timestamp with no time value (date only). For example:

SELECT TIMESTAMP_TO_DATE(SYSDATE) FROM DUAL