1. Learn
  2. /
  3. Courses
  4. /
  5. Time Series Analysis in PostgreSQL

Exercise

Converting dates

In this scenario, you are on the data integration team at an e-commerce retail store. You have a fact_table that has been imported from a file. The fact table has a product id field and a create_date text field containing the date that id was created. It is available in the console.

Your task is to create a format string for tables that correctly parses the date field.

Instructions

100 XP
  • Convert the create_date text field into a date field using the correct formatting.