hour_of_day

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>

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).

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