Built-in Functions → formatDuration

formatDuration() is a scalar date function that converts a time value into a duration. The function takes an integer value and returns a time value given milliseconds.

Signature

formatDuration(int duration)

The following table illustrates the formatDuration() parameter: | Parameter | Description | |-|-| | int duration | int to convert into a duration |

Returns

timestamp

Example

formatDuration(900000)

In this example, The function takes the input of 900000 and returns 00:15:00.