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

Question

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.

So you just want to divide all numbers by `100`? – MSH Apr 18 '22 at 22:13 — MSH, Apr 18 '22 at 22:13

ML_Enthu · Accepted Answer · 2022-04-18T22:16:55.100

0

In python,

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

In SQL,

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

edited Apr 18 '22 at 22:16

answered Apr 18 '22 at 21:50

ML_Enthu

314
1
3
12

thank you! this worked – devteight Apr 18 '22 at 23:12
Great, kindly approve and vote for it. – ML_Enthu Apr 19 '22 at 05:41

score 0 · Answer 2 · answered Apr 18 '22 at 22:08

0

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.

answered Apr 18 '22 at 22:08

kenntnisse

429
2
12

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

2 Answers2