Sql, Postgresql, Programming, Postgres, Data Science.
First of all, converting to/from dates and text is a very common task, and knowing this basic pattern will likely help. More generally, be aware that there are multiple ways to convert column types. It might take a little bit of searching if the ALTER … TYPE approach doesn’t work, but a solution