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,
JavaScript
x
2
1
print(format(54200/100, ".2f"))
2
In SQL,
JavaScript
1
3
1
SELECT
2
CAST(54200/100 AS DECIMAL(7,2)) AS x;
3