title	description	ms.reviewer	ms.topic	ms.date
todatetime()	Learn how to use the todatetime() function to convert the input expression to a datetime value.	alexans	reference	01/08/2024

todatetime()

Converts the input to a datetime scalar value.

Note

When possible, use datetime literals instead.

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.

[!div class="nextstepaction"] Run the query

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

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

[!div class="nextstepaction"] Run the query

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

Output

print_0
true