Re: Format an Update with calculation

[Ron <ronljohnsonjr@xxxxxxxxx>]

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.