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.