Differences
This shows you the differences between two versions of the page.
| |
query_2:correct_ar8percision [2020/05/22 07:38] – created sweitmann | query_2:correct_ar8percision [2020/05/22 07:42] (current) – sweitmann |
---|
Two queries: | Two queries: |
| |
UPDATE ar SET amount=ROUND(amount::numeric,2), netamount = round(netamount::numeric,2), paid=ROUND(paid::numeric,2), fxamount = ROUND(fxamount::numeric,2), fxpaid = ROUND(fxpaid::numeric,2) WHERE amount - paid BETWEEN 0.0009 AND 0.009; | UPDATE ar SET amount=ROUND(amount::numeric,2), netamount = round(netamount::numeric,2), paid=ROUND(paid::numeric,2), fxamount = ROUND(fxamount::numeric,2), fxpaid = ROUND(fxpaid::numeric,2) WHERE amount - paid BETWEEN 0.00001 AND 0.009; |
| |
and | and |
| |
UPDATE ar SET amount=ROUND(amount::numeric,2), netamount = round(netamount::numeric,2), paid=ROUND(paid::numeric,2), fxamount = ROUND(fxamount::numeric,2), fxpaid = ROUND(fxpaid::numeric,2) WHERE paid - amount BETWEEN 0.0009 AND 0.009; | UPDATE ar SET amount=ROUND(amount::numeric,2), netamount = round(netamount::numeric,2), paid=ROUND(paid::numeric,2), fxamount = ROUND(fxamount::numeric,2), fxpaid = ROUND(fxpaid::numeric,2) WHERE paid - amount BETWEEN 0.00001 AND 0.009; |
| |