Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.omni.co/llms.txt

Use this file to discover all available pages before exploring further.

Filters time fields by the hour of the day. Returns rows where the timestamp falls within the specified hour.

​
Syntax

<time_field>:
  hour_of_day: <hour_number>

​
Properties

​
time_field
string
required
The time/timestamp field to filter on, specified in the format view_name.field_name.
​
hour_of_day
number
required
The hour of the day to filter for. Must be a number between 0 (midnight) and 23 (11 PM).

​
Examples

Time falls between 9-9:59 AM
users.created_at:
  hour_of_day: 9
Time falls between 12-1 AM
events.event_time:
  hour_of_day: 0