todatetime()
Learn how to use the todatetime() function to convert the input expression to a datetime value.
Converts the input to a datetime scalar value.
Syntax
todatetime(value)
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| value | scalar | ✔️ | The value to convert to datetime. |
Returns
If the conversion is successful, the result is a datetime value.
Else, the result is 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 |
Related content
- make-datetime function
- Scalar function types at a glance
- The datetime data type
- datetime_add function
- Datetime / timespan arithmetic
- totimespan 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.