Skip to main content
Version: 11.0

TIMESTAMP_TO_DATE

note

This article has additional information about the TIMESTAMP_TO_DATE SQL function. For convertibility of this function, go to SQL functions  S - Z.

TIMESTAMP_TO_DATE​

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.