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.
Bu egzersiz
Time Series Analysis in PostgreSQL
kursunun bir parçasıdırEgzersiz talimatları
- Convert the
created_attext field into a date and time field using the correct formatting.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- 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;