Format number

[lesstjm]

I want to convert a number to a char and make sure it has 3 digits after the decimal.

Select to_char(222.1,'??????') from dual;

I want it to look like 222.100.


How do I do this??

[slimdave]

to_char(222.1,'990.000')

Alsohave a look at the SQL Reference --all the possible elements of to_char() and to_date() and listed and explained