to_date
function (Databricks SQL)
Returns expr
cast to a date using an optional formatting.
Arguments
expr
: A STRING expression representing a date.fmt: An optional format STRING expression.
Returns
A DATE.
If fmt
is supplied, it must conform with Datetime patterns (Databricks SQL).
If fmt
is not supplied, the function is a synonym for cast(expr AS DATE)
.
If fmt
is malformed or its application does not result in a well formed date, the function raises an error.