AS_DATE

Strict casting VARIANT values to DATE data type. If the input data type is not VARIANT, the output is NULL. If the type of value in the VARIANT does not match the output value, the output is NULL.

Syntax

AS_DATE( <variant> )

Arguments

Return Type

DATE

Examples

SELECT as_date(to_date('2025-10-11')::variant);
+-----------------------------------------+
| as_date(to_date('2025-10-11')::variant) |
+-----------------------------------------+
| 2025-10-11                              |
+-----------------------------------------+

SELECT as_date(parse_json('"2024-12-25"')::variant);
+-----------------------------------------------+
| as_date(parse_json('"2024-12-25"')::variant) |
+-----------------------------------------------+
| 2024-12-25                                    |
+-----------------------------------------------+

-- Returns NULL for non-date values
SELECT as_date(parse_json('123'));
+----------------------------+
| as_date(parse_json('123')) |
+----------------------------+
| NULL                       |
+----------------------------+