SELECT mathematical functions
Built-In Mathematical SQL Functions
SELECT ceil(3.1);
SELECT ceil(-3.1);
SELECT floor(3.8);
SELECT floor(-3.8);
SELECT trunc(3.8);
SELECT trunc(-3.8);
$ sqlite3 < examples/math.sql
SELECT ceil(3.1);
SELECT ceil(-3.1);
SELECT floor(3.8);
SELECT floor(-3.8);
SELECT trunc(3.8);
SELECT trunc(-3.8);