I have a quite complex query which is not behaving as I want it to.
I have boiled it down to a small example that shows my problem:
it returns 30.939999872
I want it to return 30.94 or 30.94000000000
Can I do some kind of conversion to other datatypes in the select statement orwhat should I do. I need it to be able to do this kind of calculation without making decimal errors.
Thanks in advance