Re: Format an Update with calculation

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




-- 
Adrian Klaver
adrian.klaver@aklaver.com