totimespan()

Learn how to use the totimespan() function to convert the input to a timespan scalar value.

Converts the input to a timespan scalar value.

Syntax

totimespan(value)

Parameters

Name	Type	Required	Description
value	`string`	✔️	The value to convert to a timespan.

Returns

If conversion is successful, result is a timespan value. Else, result is null.

Example

The following example shows different usage of totimespan:

let value=5;
print minsStr=totimespan("0.00:03:00"), days=totimespan(4d), hour=totimespan(value * 1h), 
      mins=totimespan(value * 2m), seconds=totimespan(5 * 4s), timespanMin=timespan(25min)

Output

minsStr	days	hour	mins	seconds	timespanMin
00:03:00	4.00:00:00	05:00:00	00:10:00	00:00:20	00:25:00

Scalar function types at a glance
timespan datatype
make-timespan function

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.