drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Givre <cgi...@gmail.com>
Subject Re: how to show decimal upto 2 points
Date Wed, 08 Feb 2017 15:15:18 GMT
Hi Sanjiv, 
You have a few options…
You can use the ROUND() function IE:

SELECT ROUND( `col1`, 2 ) AS col1 FROM… 

OR you can use the TO_CHAR() function like this:

SELECT TO_CHAR( `col1`, ‘#,###.##’ ) AS col1 FROM… 

The biggest difference is that the ROUND() function gets you numeric data types whereas TO_CHAR()
gets you a VARCHAR. 
Hope this helps, 
— Charles




> On Feb 8, 2017, at 08:17, Sanjiv Kumar <sanjivktr@gmail.com> wrote:
> 
> Hi
> 
> Drill Environment:- OS:- Window 10
>                   Version:- 1.9
>                   Mode:- embedded mode
> I have query i have set planner.enable_decimal_data_type=true and while
> firing select command in drill i got output in decimal value but it showing
> like 11936.369999999997.
> 
> I want to display only upto 2 or 3 value after decimal. like (11936.36).
> 
> Is there any options are there to show upto decimal upto 2 value.?​
> 
> -- 
> Thanks & Regards.
> Sanjiv Kumar.


Mime
View raw message