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