Get startedGet started for free

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.

This exercise is part of the course

Time Series Analysis in PostgreSQL

View Course

Exercise instructions

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

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Convert the created_at text field into dates and times
SELECT 
    id, 
    ___(created_at, '___') AS created_at 
FROM fact_table
ORDER BY id, created_at;
Edit and Run Code