Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

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);