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