try_to_timestamp
function
Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above
Returns expr
cast to a timestamp using an optional formatting, or NULL
if the cast fails.
Arguments
expr
: A STRING expression representing a timestamp.fmt: An optional format STRING expression.
Returns
A TIMESTAMP.
If fmt
is supplied, it must conform with Datetime patterns.
If fmt
is not supplied, the function is a synonym for cast(expr AS TIMESTAMP)
.
If fmt
is malformed, the function raises an error.
If expr
cannot be transformed into a timestamp using fmt
, the function returns NULL
.