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

Exercise

Converting date and times

This time you have received a fact_table that has a product id column and a created_at text column containing the date and time that id was created. It is available in the console.

Your task is to create a format string for tables that correctly parses both the dates and times in the field.

Instructions

100 XP
  • Convert the created_at text field into a date and time field using the correct formatting.