TIME_BUCKET

DuckDB

time_bucket(bucket_width, timestamp, origin)

• bucket_width: INTERVAL
• timestamp: DATE
• origin: INTERVAL

Example

SELECT time_bucket(INTERVAL '2 weeks', TIMESTAMP '1992-04-20 15:26:00-07', TIMESTAMP '1992-04-01 00:00:00-07');