Hello.There is date_trunc(interval, timestamptz, timezone) function.First parameter can be '5 year', '2 month', '6 hour', '3 hour', '15 minute', '10 second' etc.-- Przemysław Sztoch | Mobile +48 509 99 00 66