On Fri, 16 Dec 2011 00:06:54 +1030
Michael Rowan <mike(dot)rowan(at)internode(dot)on(dot)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".
In response to
pgsql-novice by date
|Next:||From: richard terry||Date: 2011-12-16 10:57:40|
|Subject: question re incrementing an integer field in a table.|
|Previous:||From: Jayadevan M||Date: 2011-12-15 13:45:04|
|Subject: Re: Rounding result of expression in SELECT ..AS..|