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
.
This exercise is part of the course
Analyzing Business Data in SQL
Exercise instructions
- Select the order date.
- Format the order date so that
2018-06-01
is formatted asFriday 01, June 2018
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT DISTINCT
-- Select the order date
___,
-- Format the order date
___(___, ___) AS format_order_date
FROM orders
ORDER BY order_date ASC
LIMIT 3;