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.
ToDuration(650000000)
Result: 1 minute and 5 seconds
ToDuration(50000000)
Result: 5 seconds
ToDuration(unknownnumber)
Result: unknown
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(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
| Name | Type | Required | Description |
|---|---|---|---|
text
text
text containing duration in dd.HH:mm:ss:fff form
ticks
numeric
the number of ticks (tenthousandth of a millisecond)
number
numeric
a numeric value to combine with the date_unit
date_unit
keyword
one of the date_units: day, hour, minute, second, millisecond
day
numeric
the day unit (number of days)
hour
numeric
the hour unit (0 - 23)
minute
numeric
the minute unit (0 - 59)
second
numeric
the second unit (0 - 59)
millisecond
numeric
the millisecond unit (0 - 999)