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.
Diese Übung ist Teil des Kurses
Time Series Analysis in PostgreSQL
Anleitung zur Übung
- Convert the
create_datetext field into a date field using the correct formatting.
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Convert the create_date text field into dates
SELECT
id,
___(create_date, '___') AS create_date
FROM fact_table
ORDER BY id, create_date;