sql cast to str with zero after dot

Question

How can i get '186.60' string from 186.6 number in sql ?

select( 186.6::varchar);

result is

'186.6'

can you provide a [minimal-reproducible-example](https://stackoverflow.com/help/minimal-reproducible-example) — A.Steer, Mar 10 '22 at 11:31
you might want to convert decimal places: https://stackoverflow.com/questions/441600/write-a-number-with-two-decimal-places-sql-server — simno, Mar 10 '22 at 11:39

score 1 · Accepted Answer · answered Mar 10 '22 at 15:48

1

 select to_char(186.6, 'FM999D90');
 to_char 
---------
 186.60

Where 9 represents not significant digits and 0 represents significant digits. The FM(fill mode) preserves leading and trailing zeros.

answered Mar 10 '22 at 15:48

Adrian Klaver

score 0 · Answer 2 · answered Mar 10 '22 at 11:42

0

select(162.4::numeric(10,2)::varchar);

will return

162.40

answered Mar 10 '22 at 11:42

2 Answers2