TIMEPART Function

Returns the time as hours, minutes, and seconds.

Category: Date and Time
Returned data type: TIME

Syntax

TIMEPART(ts)

Arguments

ts

specifies the timestamp.

Example

The following statement illustrates the TIMEPART function:
Statements
Results
select timepart(timestamp '2013-10-30 15:39:10');
15:39:10
Last updated: February 23, 2017