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.
Deze oefening maakt deel uit van de cursus
Time Series Analysis in PostgreSQL
Oefeninstructies
- Convert the field
datestringin thedc_datestringstable intoDATEdata type.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Convert the datestring data type
SELECT
___ AS dates
FROM dc_datestrings;