This should do it: https://drill.apache.org/docs/data-type-conversion/#to_char-syntax
-----Original Message----- From: Brandon [mailto:etu...@gmail.com] Sent: Saturday, November 04, 2017 5:13 AM To: user@drill.apache.org Subject: Formatting results 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