AuthorMessage
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.