Getting decimal out of query

[ecannizzo]

I have a query that takes a number(5,2) out of a database table. Problem is, if there is no decimal part it does not put the .00 at the end of it. Is there anyway to do this in the query.
For instance,

select amount from tablename

This give me 50. I want to format it to bring back 50.00.

Any ideas?
Thanks!

 

[ecannizzo]

I figured it out.

to_char(amount , '999.00')