# DATE\_TRUNC

Kürzt ein Datum auf eine angegebene Zeiteinheit.

## Syntax

```
DATE_TRUNC(unit, time)
```

## Argumente

| Name | Typ | Beschreibung | Standardwert |
| --- | --- | --- | --- |
| Einheit | String |  |  |
| Uhrzeit | timestamp |  |  |

## Rückgaben

timestamp

***

## Beispiele

| Einheit | Uhrzeit | Ausgabe |
| --- | --- | --- |
| "Millisekunde" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 04:05:06.789" |
| "Sekunde" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 04:05:06" |
| "Minute" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 04:05:00" |
| "Stunde" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 04:00:00" |
| "Tag" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 00:00:00" |
| "Woche" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-01 00:00:00" |
| "Monat" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-01 00:00:00" |
| "Quartal" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-01-01 00:00:00" |
| "Jahr" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-01-01 00:00:00" |
| "Millisekunde" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 23:59:59.999" |
| "Sekunde" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 23:59:59" |
| "Minute" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 23:59:00" |
| "Stunde" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 23:00:00" |
| "Tag" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 00:00:00" |
| "Woche" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-27 00:00:00" |
| "Monat" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-01 00:00:00" |
| "Quartal" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-10-01 00:00:00" |
| "Jahr" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-01-01 00:00:00" |
| "Test" | timestamp "2021-12-31 23:59:59.999" | null |