'Converting a column stored as a price string to double numbers in SQL

I have a column in a table named price that has values that are strings like so:

$170.00

How can I use SQL to convert these price strings into double numbers?

I am using Postgresql with Heroku

sqlpostgresqltype-conversion


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions