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
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных