v.20.1New Feature
Add bankerRound function for banker's rounding
Why it matters
Banker's rounding (also known as round half to even) provides a statistically unbiased rounding method, reducing cumulative rounding errors compared to traditional rounding. This is especially useful in financial and statistical calculations to improve accuracy.How to use it
Use thebankerRound function in your SQL queries to round numbers following banker's rounding rules. For example:SELECT bankerRound(your_column) FROM your_table;