DATE_TRUNC
Tronca una data a una data unità di tempo.
Sintassi
DATE_TRUNC(unit, time)
Argomenti
| Nome | Tipo | Descrizione | Valore predefinito |
|---|---|---|---|
| unità | stringa | ||
| ora | data e ora |
Restituisce
data e ora
Esempi
| unità | ora | Output |
|---|---|---|
| "millisecondo" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 04:05:06.789" |
| "secondo" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 04:05:06" |
| "minuto" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 04:05:00" |
| "ora" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 04:00:00" |
| "giorno" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-03 00:00:00" |
| "settimana" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-01 00:00:00" |
| "mese" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-02-01 00:00:00" |
| "trimestre" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-01-01 00:00:00" |
| "anno" | timestamp "2021-02-03 04:05:06.789" | timestamp "2021-01-01 00:00:00" |
| "millisecondo" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 23:59:59.999" |
| "secondo" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 23:59:59" |
| "minuto" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 23:59:00" |
| "ora" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 23:00:00" |
| "giorno" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 00:00:00" |
| "settimana" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-27 00:00:00" |
| "mese" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-01 00:00:00" |
| "trimestre" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-10-01 00:00:00" |
| "anno" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-01-01 00:00:00" |
| "prova" | timestamp "2021-12-31 23:59:59.999" | null |