rfc:change_the_edge_case_of_round

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
rfc:change_the_edge_case_of_round [2023/11/08 14:59] – sakirfc:change_the_edge_case_of_round [2023/11/08 15:04] – saki
Line 105: Line 105:
 |            0.29 | |            0.29 |
 +-----------------+ +-----------------+
 +
 +mysql> SELECT ROUND(0.28499999999999998, 2);
 ++-------------------------------+
 +| ROUND(0.28499999999999998, 2) |
 ++-------------------------------+
 +|                          0.28 |
 ++-------------------------------+
 </code> </code>
  
Line 113: Line 120:
 ------- -------
   0.29   0.29
 +
 +postgres=# SELECT ROUND(0.28499999999999998, 2);
 + round 
 +-------
 +  0.28
 </code> </code>
  
Line 118: Line 130:
 <code> <code>
 sqlite> SELECT ROUND(0.285, 2); sqlite> SELECT ROUND(0.285, 2);
 +0.29
 +
 +sqlite> SELECT ROUND(0.28499999999999998, 2);
 0.29 0.29
 </code> </code>
Line 128: Line 143:
 =====================  ===================== 
                 0.290                  0.290 
 +
 +SQL> SELECT ROUND(0.28499999999999998, 2) FROM RDB$DATABASE;
 +
 +                ROUND 
 +===================== 
 +  0.28000000000000000 
 </code> </code>
  
Line 137: Line 158:
 ----- -----
  .290  .290
 +
 +1> SELECT ROUND(0.28499999999999998, 2);
 +2> go
 +                   
 +-------------------
 + .28000000000000000
 </code> </code>
  
rfc/change_the_edge_case_of_round.txt · Last modified: 2023/12/08 00:37 by saki

Page Tools