Re: Format an Update with calculation

[Ron]

On 12/19/2018 02:12 AM, Condor wrote:

On 18-12-2018 15:51, Adrian Klaver wrote:

[snip]

In addition to what Pavel posted:

select round(43.2335, 2);

 round
-------
 43.23

Beware with round and numeric

select round(43.2375, 2);
 round
-------
 43.24


 select 43.2375::numeric(17, 2);
 numeric
---------
   43.24

Beware of what?


--
Angular momentum makes the world go 'round.