Rounding cell

Note: please leave bug reports and feature requests on

Rounding cell

Postby alego » Mon Oct 05, 2015 1:50 pm

Hi.
I've a DECIMAL(5,4) column on a table. When I query it it shows 0,066 instead of 0,0657 It seems a rounding problem. Where can I configure it on DBeaver to show a non rounding result?
I'm using 3.5.1 version.
tks
Last edited by alego on Tue Oct 06, 2015 1:29 pm, edited 1 time in total.
alego
 
Posts: 10
Joined: Thu Jan 08, 2015 12:46 pm

Re: Truncate cell

Postby Serge » Mon Oct 05, 2015 2:20 pm

You can configure it in Data Formats preferences. Set maximum fraction digits to some reasonable value.
Then reopen table editor.
Attachments
numeric-df.png
numeric-df.png (51.68 KiB) Viewed 7419 times
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Truncate cell

Postby alego » Tue Oct 06, 2015 1:33 pm

alego
 
Posts: 10
Joined: Thu Jan 08, 2015 12:46 pm


Return to Support



Who is online

Users browsing this forum: No registered users and 8 guests