Link Search Menu Expand Document

TO_MINUTE

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

Syntax

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

Example

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

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

Returns: 20