FROM_ISO8601_DATE
Description
Converts an ISO8601 formatted date expression to a DATE type date expression.
Syntax
from_iso8601_date(<dt>)Parameters
| Parameter | Description |
|---|---|
<dt> | An ISO8601 formatted date |
Return Value
A DATE type date expression.
Examples
SELECT from_iso8601_date('0000-01'),from_iso8601_date('0000-W01'),from_iso8601_date('0000-059');+------------------------------+-------------------------------+-------------------------------+
| from_iso8601_date('0000-01') | from_iso8601_date('0000-W01') | from_iso8601_date('0000-059') |
+------------------------------+-------------------------------+-------------------------------+
| 0000-01-01 | 0000-01-03 | 0000-02-28 |
+------------------------------+-------------------------------+-------------------------------+