The date function used to format a date or datetime value, according to a given format string. A wide variety of formatting 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 |
|---|---|
dateValue | datetime, date, time, datetimestamp, gyear, gyearmonth |
formatString | string |
query:
SELECT DATE_FORMAT(CAST("2018-01-02" AS DATE), "yyyy.MM.dd G 'at' HH:mm:ss z")results:
| date_format |
|---|
| 2018.01.02 AD at 00:00:00 UTC |