SQL · Numeric functions

trunc()

Truncates decimals without rounding. SQLite builds without math functions can use CAST.

sqlRunnable example sql course

Syntax

trunc(number, decimals)

Example

Open in the lab

SELECT cast(3.99 AS integer) AS truncated;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.