jeudi 18 février 2016

Rounding to nearest or up in SQLite

I've got an existing calculation (in SQL) which contains several formulas involving rounding. Now I've got to make sure that the rounding uses the half up tie-breaking alorithm.

It appears that by default, SQLite's round function uses the half to even algorithm.

Is there a simple way to change that to half up?

Aucun commentaire:

Enregistrer un commentaire