todatetime()

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

Converts the input to a datetime scalar value.

todatetime(value)

Learn more about syntax conventions.

If the conversion is successful, the result is a datetime value. Else, the result is 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

• make-datetime function
• Scalar function types at a glance
• The datetime data type
• datetime_add()
• Datetime / timespan arithmetic
• totimespan()