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

Exercise

Casting dates

Oftentimes, you will want to conveniently parse a wide variety of date strings with as little code as possible.

In this exercise, you will take on the role of a software engineer at a fintech startup testing a search engine bot. For the purpose of performing financial data aggregation and data quality analysis, you have collected several sample date strings and put them into a table called dc_datestrings.

Instructions

100 XP
  • Convert the field datestring in the dc_datestrings table into DATE data type.