User Tools

Site Tools


query_2:correct_ar8percision

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

query_2:correct_ar8percision [2020/05/22 07:38]
sweitmann created
query_2:correct_ar8percision [2020/05/22 07:42] (current)
sweitmann
Line 1: Line 1:
 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;
  
query_2/correct_ar8percision.txt ยท Last modified: 2020/05/22 07:42 by sweitmann