SQLite Forum

Round function returning -0.0
Login
Hi,
using SQLite 3.36.0 on a Windows 10 system, I noticed that the `round()` function will return `-0.0` when trying to round `0.0`.

Specifically, assuming that `myVar` has the value `0.0`, I noticed that

* `round(myVar)` will return `0.0`, while
* `round(myVar, 1)` will return `-0.0`

Is this the expected behavior? Can I have a work around to always round zero to `0.0` without a sign?