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;