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
