# DATE\_TRUNC

Trunkera ett datum till en given tidsenhet.

## Syntax

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

## Argument

| Namn | Typ | Beskrivning | Standardvärde |
| --- | --- | --- | --- |
| enhet | sträng |  |  |
| tid | tidsmarkör |  |  |

## Returnerar

tidsmarkör

***

## Exempel

| enhet | tid | Utdata |
| --- | --- | --- |
| "millisekund" | tidsmarkör "2021-02-03 04:05:06.789" | tidsmarkör "2021-02-03 04:05:06.789" |
| "sekund" | tidsmarkör "2021-02-03 04:05:06.789" | tidsmarkör "2021-02-03 04:05:06" |
| "minut" | tidsmarkör "2021-02-03 04:05:06.789" | tidsmarkör "2021-02-03 04:05:00" |
| "timme" | tidsmarkör "2021-02-03 04:05:06.789" | tidsmarkör "2021-02-03 04:00:00" |
| "dag" | tidsmarkör "2021-02-03 04:05:06.789" | tidsmarkör "2021-02-03 00:00:00" |
| "vecka" | tidsmarkör "2021-02-03 04:05:06.789" | tidsmarkör "2021-02-01 00:00:00" |
| "månad" | tidsmarkör "2021-02-03 04:05:06.789" | tidsmarkör "2021-02-01 00:00:00" |
| "kvartal" | tidsmarkör "2021-02-03 04:05:06.789" | tidsmarkör "2021-01-01 00:00:00" |
| "år" | tidsmarkör "2021-02-03 04:05:06.789" | tidsmarkör "2021-01-01 00:00:00" |
| "millisekund" | tidsmarkör "2021-12-31 23:59:59.999" | tidsmarkör "2021-12-31 23:59:59.999" |
| "sekund" | tidsmarkör "2021-12-31 23:59:59.999" | tidsmarkör "2021-12-31 23:59:59" |
| "minut" | tidsmarkör "2021-12-31 23:59:59.999" | tidsmarkör "2021-12-31 23:59:00" |
| "timme" | tidsmarkör "2021-12-31 23:59:59.999" | tidsmarkör "2021-12-31 23:00:00" |
| "dag" | tidsmarkör "2021-12-31 23:59:59.999" | tidsmarkör "2021-12-31 00:00:00" |
| "vecka" | tidsmarkör "2021-12-31 23:59:59.999" | tidsmarkör "2021-12-27 00:00:00" |
| "månad" | tidsmarkör "2021-12-31 23:59:59.999" | tidsmarkör "2021-12-01 00:00:00" |
| "kvartal" | tidsmarkör "2021-12-31 23:59:59.999" | tidsmarkör "2021-10-01 00:00:00" |
| "år" | tidsmarkör "2021-12-31 23:59:59.999" | tidsmarkör "2021-01-01 00:00:00" |
| "test" | tidsmarkör "2021-12-31 23:59:59.999" | null |