SQLite 3 reference · Math Functions
SQLite TRUNC() Function
Drop the fractional part of a number, rounding toward zero: trunc(2.7) is 2 and trunc(-2.7) is -2.
SQLite 3 Since 3.35.0
Syntax
trunc(X)
Parameters
| Parameter | Description |
|---|---|
X |
A number (text that looks like a number is converted). |
Return value
The integer part, as a number.
Examples
SELECT trunc(2.7) AS a, trunc(-2.7) AS b, floor(-2.7) AS floor_b;
Output
a | b | floor_b 2 | -2 | -3
Run this on your computer — see “Get Started” for setup.
SELECT CAST(-2.7 AS INTEGER) AS cast_int;
Output
cast_int -2
Run this on your computer — see “Get Started” for setup.
This is one of SQLite's built-in math functions, available since 3.35.0 when SQLite is compiled with
SQLITE_ENABLE_MATH_FUNCTIONS (the default for the sqlite3 command-line tool and most language bindings). The
in-browser SQLite on this site is built without them, so the examples show output from standard SQLite instead.
Version history
| Version | Change |
|---|---|
| SQLite 3.35.0 | Added |
In other languages
TRUNC()· PostgreSQL
Related
FLOOR()· Return the largest integer value not greater than a number, rounding down: floor(2.9) is 2 and floor(-2.1) is -3.CEIL()· Return the smallest integer value not less than a number, rounding up: ceil(2.1) is 3. ceiling() is a synonym.ROUND()· Round a number to a given number of decimal places (0 by default). Halves round away from zero.- SQL Aggregate Functions · tutorial