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 <sanjiv...@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.
