TIMESTAMP_TO_DATE

This article has additional information about the TIMESTAMP_TO_DATE SQL function.

For convertibility of this function, go to SQL functions S - Z.

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

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

Be the first to reply!

Sign up for the USoft Community