date_floor

XQL_function_descriptions.json

Synopsis

date_floor(field OR expr: timestamp [, kind: string, timezone: string])

Description

Rounds a timestamp value for a particular field or function result down to the nearest whole value of a specified timestamp unit, including a year (y), month (mo), week (w), day (d) or hour (h). Default timezone is UTC