Reference Guide > TDV Support for SQL Functions > Date Functions > TIME_SLICE
 
TIME_SLICE
Aggregates data by different fixed-time intervals and returns a rounded-up input TIMESTAMP value to a value that corresponds with the start or end of the time slice interval.
Syntax
TIME_SLICE( expression, slice-length [, 'time‑unit' [, 'start‑or‑end' ] ] )
Example
SELECT TIME_SLICE('2020-06-20 00:00:01', 3);