KATER__DAY_OF_MONTH

Family: Date parts

Syntax

1
KATER__DAY_OF_MONTH(field)

Arguments

Returns

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

Usage notes

• A month has 28 to 31 days, so not every month has days 29 to 31.

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.order_date AS "Order Date",
4
  DIMENSION('order_date_day_of_month', KATER__DAY_OF_MONTH(orders.order_date)) AS "Day of Month"
5
FROM kater_dataset.orders AS orders
6
ORDER BY
7
  1
8
LIMIT 3

Compiles to

1
EXTRACT(DAY FROM orders.order_date)

1
DATE_PART(DAY, orders.order_date)

See also

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