Get startedGet started for free

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.

This exercise is part of the course

Time Series Analysis in PostgreSQL

View Course

Exercise instructions

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

Hands-on interactive exercise

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

-- Convert the datestring data type
SELECT 
    ___ AS dates
FROM dc_datestrings; 
Edit and Run Code