Convert an INT value to a decimal with 2dp

Question

I am trying to convert an INT value (i.e. 12345) to a decimal with 2dp. The example output should therefore become 123.45.

I am getting most of the data as INT values, I'd need a way to get the last two digits effectively to be part of the decimal place.

Answer 1

How about just divide by 100?

select value/100 as value
from table;