trinodb/trino

Document `truncate(number, position)` function

Open

#28765 opened on Mar 19, 2026

View on GitHub
 (2 comments) (0 reactions) (0 assignees)Java (9,113 stars) (2,678 forks)batch import
good first issueneeds-docs

Description

https://trino.io/docs/current/functions/math.html#truncate documents only truncate(number) truncate(number, position) is currently not documented. It's supported for decimal and number types.

see round docs https://trino.io/docs/current/functions/math.html#round for example

cc @mosabua

Contributor guide

Tech stack
java
Domain
documentation
Issue type
documentation
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
under 1 hour
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
basic SQL knowledgefamiliarity with Markdown
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
90
Research direction
The issue requests documenting the `truncate(number, position)` function. The existing documentation for `truncate(number)` is in the Trino documentation math functions file, likely at `docs/src/main/docs/functions/math.md`. The `round` function documentation provides a good example of how to document multi argument forms. The new documentation should specify that `truncate` with two arguments is supported for `decimal` and `number` types. To verify, one can build the docs locally using Maven or examine the round function's format.