TO_START_OF_INTERVAL

to_start_of_interval(ts， interval)

功能

将时间 ts 按照 interval 截断。注意当 interval 为分钟时，需要保证其能被 1 天整除。

参数

• ts

  ts
  timestamp

• interval

  interval
  interval_day_time/interval_year_month

返回结果

timestamp

举例

> 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