Cacher is the code snippet organizer for pro developers

SELECT CAST(columna AS MONEY(8,2)) FROM tabla;

-- o con el operador ::

SELECT idprov, (idprov[3,4]+60)::INT::VARCHAR(5) AS subcod
FROM provincias