# DATE\_TRUNC

Trunca uma data para uma determinada unidade de tempo.

## Sintaxe

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

## Argumentos

| Nome | Tipo | Descrição | Valor padrão |
| --- | --- | --- | --- |
| unit | caractere |  |  |
| tempo | carimbo de data/hora |  |  |

## Retorna

carimbo de data/hora

***

## Exemplos

| unit | tempo | Saída |
| --- | --- | --- |
| "millisecond" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 04:05:06.789" |
| "second" | 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" |
| "hour" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 04:00:00" |
| "day" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 00:00:00" |
| "week" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-01 00:00:00" |
| "month" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-01 00:00:00" |
| "quarter" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-01-01 00:00:00" |
| "year" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-01-01 00:00:00" |
| "millisecond" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 23:59:59.999" |
| "second" | 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" |
| "hour" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 23:00:00" |
| "day" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 00:00:00" |
| "week" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-27 00:00:00" |
| "month" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-01 00:00:00" |
| "quarter" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-10-01 00:00:00" |
| "year" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-01-01 00:00:00" |
| "test" | timestamp "2021-12-31 23:59:59.999" | nulo |