Format an Update with calculation
| От | Bret Stern |
|---|---|
| Тема | Format an Update with calculation |
| Дата | |
| Msg-id | 1545117297.4397.18.camel@dell990-bret-centos.localdomain обсуждение исходный текст |
| Ответы |
Re: Format an Update with calculation
Re: Format an Update with calculation Re: Format an Update with calculation |
| Список | pgsql-general |
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
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
В списке pgsql-general по дате отправления: