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??
Printable View
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??
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