How do I get decimal values?

Question

I have two columns on my database, sickleave and vacationleave. It has to be a decimal but for some reason I only get the whole number. For example, I input 1.50, when I press update I get the value 2. I tried setting the column type to decimal but I still get the same result.

Here's my database schema:

change `decimal(11,0)` to something like `decimal(11,1)` .. depends on how precise you want to store your data — B001ᛦ, Jan 12 '18 at 10:18

user3647971 · Answer 1 · 2018-01-12T10:38:46.180

1

From the mysql documentation:

The declaration syntax for a DECIMAL column is DECIMAL(M,D). The ranges of values for the arguments are as follows:

M is the maximum number of digits (the precision). It has a range of 1 to 65.
D is the number of digits to the right of the decimal point (the scale). It has a range of 0 to 30 and must be no larger than M.

So in your case: hit change button there and in the Length/value column there should be: 11,2 with no parentheses or anything else when you hit save

In case you want to do it manually there's a discussion of it here: MySQL - How do I update the decimal column to allow more digits?

And here's the alter: ALTER TABLE YourTableName MODIFY COLUMN column_name DECIMAL(11,2);

edited Jan 12 '18 at 10:38

answered Jan 12 '18 at 10:24

user3647971

1,069
1
6
13

I understand but when I tried to change it, it goes back to 11,0 – Renzo Jan 12 '18 at 10:25
1

I tested the situation and when you hit edit add "11,2" NOTHING else in the length/value column then hit save – user3647971 Jan 12 '18 at 10:28
I did put 11,2 and nothing else, I still get 11,0. Weird. – Renzo Jan 12 '18 at 10:30
Another reason could be that you have values that can't be converted into it there. So if you don't have any data in there that you'd like to keep empty the rows with wrong information that could help – user3647971 Jan 12 '18 at 10:32
1

ALTER TABLE YourTableName MODIFY COLUMN price DECIMAL(4,2); – user3647971 Jan 12 '18 at 10:37
Yep that worked out. You just have to do it manually. Thanks! – Renzo Jan 12 '18 at 10:39

score 0 · Answer 2 · answered Jan 12 '18 at 10:41

0

Tried altering it manually using:

ALTER TABLE YourTableName MODIFY COLUMN price DECIMAL(4,2);

Thanks @user3647971

answered Jan 12 '18 at 10:41

Renzo

87
1
8

How do I get decimal values?

2 Answers2