todatetime()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Converts the input to a datetime scalar value.

Note

To learn more about supported data and time formats and syntax, see The datetime data type.
When possible, use datetime literals instead of the todatetime() function.

Syntax

todatetime(value)

Name	Type	Required	Description
value	scalar	✔️	The value to convert to datetime.

If the conversion is successful, the result will be a datetime value. Else, the result will be null.

The following example converts a date and time string into a datetime value.

print todatetime("2015-12-31 23:59:59.9")

The following example compares a converted date string to a datetime value.

print todatetime('12-02-2022') == datetime('12-02-2022')

Output

print_0
true