So I have a whole number such as 45125
and want to convert to 451.25
, or 54200
to 542.00
. I want to be able to convert using both python and sql. Is there a way of doing it? I already tried researching but couldn’t find a solution.
Advertisement
Answer
In python,
print(format(54200/100, ".2f"))
In SQL,
SELECT CAST(54200/100 AS DECIMAL(7,2)) AS x;