Link Search Menu Expand Document

TO_SECOND

Converts a timestamp (any date format we support) to a number containing the second.

Syntax

TO_SECOND(<timestamp>)
Parameter Description
<timestamp> The timestamp to be converted into the number of the second.

Example

For Tuesday, April 22, 1975 at 12:20:05:

SELECT
	TO_SECOND(CAST('1975/04/22 12:20:05' AS TIMESTAMP)) as res;

Returns: 5