SQL
ICU Timestamp with Time Zone Functions
<div class="nostroke_table"></div>  
|   |   |
|:--|:--------|
| **Description** |Truncate `timestamptz` by the specified interval `bucket_width`. Bucket starts and ends are calculated using `timezone`. `timezone` is a varchar and defaults to UTC. |
| **Example** | `time_bucket(INTERVAL '2 days', TIMESTAMPTZ '1992-04-20 15:26:00-07', 'Europe/Berlin')` |
| **Result** | `1992-04-19 15:00:00-07` |  
There are also dedicated extraction functions to get the [subfields](#docs:sql:functions:datepart).