GET_DURATION_FROM_MIN

Get an ISO 8601 string representation of the duration provided in minutes.

Usage

GET_DURATION_FROM_MIN(duration)

Parameters

duration

Number

A number of minutes representing the desired duration.

Returns

String

Examples

GET_DURATION_FROM_MIN(36)	‘PT36M’
GET_DURATION_FROM_MIN(68)	‘PT1H8M’
GET_DURATION_FROM_MIN(3752)	‘P2DT14H32M’

Remarks

This function can be useful when calling aggregating functions such as AVERAGE, MAX, MIN as it converts a simple duration into the ISO 8601 format.