Author | Message |
---|---|
Nina Ametuar Posts: 134 | Does anyone know how to show result after the comma? SELECT round((11 / 6) , 3); gives 1,000 but it should give 1,833 thanks! |
Meka][Meka Unstopable Posts: 700 | what is the result when u dont use 'round' ??? is it 1.8333333 ??? or is that also incorrect? |
Nina Ametuar Posts: 134 | Hi Meka, without the round() functon it shows 1 as result, the round function shows several numbers after the comma of course but does not show 1,833 greetz |
Nina Ametuar Posts: 134 | I finally found the solution: SELECT 11.0 / 6.0; I had to specify the .0 Simple solution but took me long enough. |