The field that I am using comes in as type: text and I want to convert it to a number with 2 decimal places. For some reason the following convert it to a number but also rounds it:
"UNIT_PRICE"::numeric
"UNIT_PRICE"::decimal
both convert a 0.65000000000000 text value to 1 but I would like to get a numeric 0.65
Is it possible?