Thread: Rounding result of expression in SELECT ..AS..

I have three columns in my table:
netcost integer(9,2)
taxsum integer(9,2)
quantity integer

In my SELECT I have:

SELECT (netcost+taxsum)*quantity AS totalcost FROM etc etc

My problem is that the value in totalcost is, like, 49.500000000000

SELECT round((netcost+taxsum)*quantity, 2) AS totalcost FROM etc etc

gives the same result.   What I want is 2DP, ie 49.50 in this example.  Is there a way to achieve this?

TIA and for past help.


Michael Rowan
mike.rowan@internode.on.net

11 Kingscote Street
ALBERTON
South Australia 5014

tel 618 8240 3993

On Fri, 16 Dec 2011 00:06:54 +1030
Michael Rowan <mike.rowan@internode.on.net> wrote:


> My problem is that the value in totalcost is, like, 49.500000000000
>
> SELECT round((netcost+taxsum)*quantity, 2) AS totalcost FROM etc etc
>
> gives the same result.   What I want is 2DP, ie 49.50 in this example.
>  Is there a way to achieve this?

SELECT TRUNC(myBioutifuelCalcul, NbOfDecimalsWanted);

--
Falling in love makes smoking pot all day look like the ultimate in
restraint. -- Dave Sim, author of "Cerebus".