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