TIMESTAMP_TO_DATE

Previous Next

Converts a datetime containing time information to a date not containing time information (or implying midnight for time).

Syntax

TIMESTAMP_TO_DATE( date )

 

Example

SELECT     TIMESTAMP_TO_DATE( SYSDATE ) 
FROM       dual

Note

This is a convertible function resolved by USoft and thus supported on all RDBMS platforms.

 

See also

SQL Functions