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

enter image description here

Is it possible?