Using DATE_TRUNC
The DATE_TRUNC() function will truncate timestamp or interval data types to return a timestamp or interval at a specified precision. The precision values are a subset of the field identifiers that can be used with the EXTRACT() and DATE_PART() functions. DATE_TRUNC() will return an interval or timestamp rather than a number. For example
SELECT DATE_TRUNC('month', TIMESTAMP '2005-05-21 15:30:30');
Result: 2005-05-01 00;00:00
Now, let's experiment with different precisions and ultimately modify the queries from the previous exercises to aggregate rental activity.
Este exercício faz parte do curso
Functions for Manipulating Data in PostgreSQL
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
-- Truncate rental_date by year
SELECT ___(___, ___) AS rental_year
FROM rental;