'How to convert a full number to 2 decimal places in python and mysql?

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.

pythonmysqlsql


Solution 1:[1]

In python,

print(format(54200/100, ".2f"))

In SQL,

SELECT
  CAST(54200/100 AS DECIMAL(7,2)) AS x;

Solution 2:[2]

You can use format specifiers and f-strings in python and do

newVal = 54200/100
print(f"{newVal:.2f}")

which outputs

542.00

The 2 in the print statement is the number of decimal places it displays.

See here, which has excellent explanations.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 kenntnisse

Related Questions