The date function used to parse a date or datetime value, according to a given format string. A wide variety of parsing options are available. The full set of formatting characters supported and sample format strings can be found at https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html.
| Parameter | Type | Description |
|---|---|---|
stringValue | string | the string to parse date information from |
formatString | string | the format string |
query:
SELECT DATE_PARSE("2018/01/02", "yyyy/MM/dd")results:
| date_parse |
|---|
| 2018-01-02T00:00:00.000Z |