1 of 1

ToDuration

The ToDuration() function converts provided input to a specific Duration value. Possible values are a string ("dd.HH:mm:ss.fff"), ticks, a number with specified date-unit or specific numeric values for days, hours, minutes, seconds and milliseconds.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a Duration value compiled from the input values.

Returns Unknown if one of the parameter values is unknown or outside the common valid boundaries.

Syntax

ToDuration(text)

ToDuration("6.12:14:45")=>Result: 6 days, 12 hours, 14 minutes and 45 seconds (mark the dot between day and hour)

ToDuration("12:14")=>Result: 12 hours and 14 minutes

ToDuration("35:80:90")=>Result: unknown

ToDuration(ticks)

There are 10 thousand ticks in one millisecond, 10 million ticks in one second, 600 million ticks in one minute.

ToDuration(650000000)Result: 1 minute and 5 seconds

ToDuration(50000000)Result: 5 seconds

ToDuration(unknownnumber)Result: unknown

ToDuration(number, date_unit)

ToDuration(6, day)Result: 6 days

ToDuration(12, hour)Result: 12 hours

ToDuration(14, minute)Result: 14 minutes

ToDuration(45, second)Result: 45 seconds

ToDuration(768, millisecond)Result: 768 milliseconds

ToDuration(day, hour, minute, second, millisecond)

ToDuration(6, 12, 14, 45, 768)Result: 6 days, 12 hours, 14 minutes, 45 seconds and 768 milliseconds

ToDuration( 0, 0, 14, 45, 0)Result: 14 minutes and 45 seconds

Parameters