SQL
Calendars
The [ICU extension](#docs:extensions:icu) also supports non-Gregorian calendars using the `SET Calendar` command.
Note that the `INSTALL` and `LOAD` steps are only required if the DuckDB client does not bundle the ICU extension.  
```sql
INSTALL icu;
LOAD icu;
SET Calendar = 'japanese';
```  
Time binning operations for `TIMESTAMPTZ` will then be implemented using the given calendar.
In this example, the `era` part will now report the Japanese imperial era number.  
A list of available calendars can be pulled from the `icu_calendar_names()` table function:  
```sql
SELECT name
FROM icu_calendar_names()
ORDER BY 1;
```