Re: Format an Update with calculation

On 18-12-2018 15:51, Adrian Klaver wrote:
> On 12/17/18 11:14 PM, Bret Stern wrote:
>> My statement below updates the pricing no problem, but I want it to be
>> formatted with 2 dec points eg (43.23).
>>
>> Started playing with to_numeric but can't figure it out. Lots of
>> examples with to_char in the
>> manual, but still searching for answer.
>>
>> Can it be done?
>>
>> I want suggested_retail_price to be formatted to 2 decimal points
>>
>> UPDATE im_ci_item_transfer
>>    SET suggested_retail_price=(suggested_retail_price +
>> (suggested_retail_price * .13))
>> WHERE item_code='0025881P2';
>>
>> Feeling lazy, sorry guys
>
> 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

Regards,
HS