SQL · Functions and expressions

date_trunc()

Truncates a timestamp to a unit, ideal for grouping by period.

sqlRunnable example sql course

Syntax

date_trunc('month', ts)

Example

Open in the lab

-- PostgreSQL
-- SELECT date_trunc('month', created_at) AS month FROM lessons;

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