PostgreSQL Function Reference

DATE_TRUNC

Truncates the date/time to the specified precision.

PostgreSQL 17.5

DATE_TRUNC(field, source)

field

The precision (year, month, day, etc.).

source

The date/time value.

Examples

PostgreSQL 17.5

SELECT DATE_TRUNC('month', TIMESTAMP '2023-02-15')