TRY_TO_DATE

​

Syntax

​

Scalar

try_to_date(value [, format])

​

Arguments

​

Returns

• Type: DATE
• NULL behavior: Bad input or NULL format yields NULL. A nonconstant format raises an error. NULL temporal input yields NULL.

​

Properties

​

Examples

​

Basic example 1

SELECT try_to_date('not a date') AS result;

​

Basic example 2

SELECT try_to_date('2024-03-15') AS result;

​

Limitations

• Input types without a supported date conversion return NULL. Numeric input is not interpreted as a year.