Formatting dates

Eve from the Business Intelligence (BI) team lets you know that she's gonna need your help to write queries for reports. The reports are read by C-level execs, so they need to be as readable and quick to scan as possible. Eve tells you that the C-level execs' preferred date format is something like Friday 01, June 2018 for 2018-06-01.

You have a list of useful patterns.

Pattern	Description
`DD`	Day number (`01` - `31`)
`FMDay`	Full day name (`Monday`, `Tuesday`, etc.)
`FMMonth`	Full month name (`January`, `February`, etc.)
`YYYY`	Full 4-digit year (`2018`, `2019`, etc.)

Figure out the format string that formats 2018-06-01 as "Friday 01, June 2018" when using TO_CHAR.

Select the order date.
Format the order date so that 2018-06-01 is formatted as Friday 01, June 2018.

Exercise

Formatting dates

Instructions