Formatting results

[Brandon]

Is it possible to format query results, like printf. For example, I have 
a query:

select yr, sum(amount) from table group by year;

Amount is a float, but I'd like to apply a currency format to get 
$123,456.89 instead of 1.23456789E6. Does Drill have a format function?


Thanks.


Brandon