TO_START_OF_INTERVAL

to_start_of_interval(ts, interval)

Function

Truncates the timestamp ts to the start of the specified interval. Note that when the interval is in minutes, it must be a divisor of 1 day (i.e., it should evenly divide into 1440 minutes).

Parameters

• ts: timestamp
• interval: interval_day_time/interval_year_month

Return Value

• timestamp

Example

> SELECT
  to_start_of_interval(ts, INTERVAL 5 MINUTE),
  to_start_of_interval(ts, INTERVAL 1 DAY)
FROM VALUES
  (TIMESTAMP '1933-06-22 04:44:08.999'),
  (TIMESTAMP '1970-12-31 04:59:59.999'),
  (TIMESTAMP '1996-03-31 07:03:33.123') t(ts);
1933-06-22 04:40:00     1933-06-22 00:00:00
1970-12-31 04:55:00     1970-12-31 00:00:00
1996-03-31 07:00:00     1996-03-31 00:00:00