KATER__HOUR_OF_DAY

Family: Date parts

Syntax

1
KATER__HOUR_OF_DAY(field)

Arguments

Returns

A whole number. The field menu writes @format plain beside it, so it shows without a thousands separator.

Usage notes

• A date has no time of day, so the compiler refuses it on a date.

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  orders.order_id AS "Order ID",
3
  orders.ordered_at AS "Ordered At",
4
  DIMENSION('ordered_at_hour_of_day', KATER__HOUR_OF_DAY(orders.ordered_at)) AS "Hour of Day"
5
FROM kater_dataset.orders AS orders
6
ORDER BY
7
  1
8
LIMIT 3

Compiles to

1
EXTRACT(HOUR FROM orders.ordered_at)

1
DATE_PART(HOUR, orders.ordered_at)

See also

• Dates
• Other functions in Date parts: KATER__DAY_OF_WEEK, KATER__DAY_OF_WEEK_INDEX, KATER__DAY_OF_MONTH, KATER__DAY_OF_QUARTER, KATER__DAY_OF_YEAR, KATER__WEEK_OF_YEAR, KATER__MONTH_NUM, KATER__MONTH_NAME, KATER__QUARTER_OF_YEAR, KATER__MINUTE_OF_HOUR