totimespan()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Converts the input to a timespan scalar value.
Deprecated aliases: totime()
Note
When possible, we recommend using timespan literals instead.
Syntax
totimespan(value)
Learn more about syntax conventions.
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 checks whether the input matches the defined timespan.
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 |