GET_DURATION_FROM_MILLISEC

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

Usage

GET_DURATION_FROM_MILLISEC(duration)

Parameters

duration

Number

A number of milliseconds representing the desired duration.

Returns

String

Examples

GET_DURATION_FROM_MILLISEC(500)	‘PT0.5S’
GET_DURATION_FROM_MILLISEC(1500)	‘PT1.5S’
GET_DURATION_FROM_MILLISEC(60500)	‘PT1M0.5S’

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.