todatetime()
Applies to: ✅ 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)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| value | scalar | ✔️ | The value to convert to datetime. |
Returns
If the conversion is successful, the result will be a datetime value.
Else, the result will be null.
Example
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 |