Get startedGet started for free

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

View Course

Exercise instructions

  • Select the order date.
  • Format the order date so that 2018-06-01 is formatted as Friday 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;
Edit and Run Code