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
Rounding cell
3 posts
• Page 1 of 1
Rounding cell
by alego » Mon Oct 05, 2015 1:50 pm
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
by 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.
Then reopen table editor.
- Attachments
-
- 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
by alego » Tue Oct 06, 2015 1:33 pm
- alego
- Posts: 10
- Joined: Thu Jan 08, 2015 12:46 pm
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 8 guests