forecast_api/build/round_pool.sql

7 lines
194 B
MySQL
Raw Permalink Normal View History

UPDATE rlarp.osm_pool
SET
value_loc = round(value_loc,2),
value_usd = round(value_usd,2),
cost_usd = round(cost_usd,2),
cost_loc = round(cost_loc,2),
units = round(units,2);