Skip to Content
0
Jan 15, 2014 at 04:22 PM

Divide 111 / 7

35 Views

When we divide 111 / 7 we get as result 15

When we divide 111 / 7.0 we get as result 15,86

What should we do to get as result 15,85714......

We use the script (select 111 / 7.0 from dummy)

In our SQL scripts are a lot of formulas like var1 / 100.0

I suppose the results of this formula is 2 decimals where I had expected that it would be converted to a decimal

Thanks

Eric