KATER__DAY_OF_WEEK

Family: Date parts

Syntax

1
KATER__DAY_OF_WEEK(field)

Arguments

Returns

Text.

Usage notes

• Names sort in alphabetical order, so a table puts Fri before Mon. Sort by the number instead to keep the calendar’s order. Use KATER__DAY_OF_WEEK_INDEX.

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_week', KATER__DAY_OF_WEEK(orders.order_date)) AS "Day of Week"
5
FROM kater_dataset.orders AS orders
6
ORDER BY
7
  1
8
LIMIT 3

Compiles to

1
STRFTIME(orders.order_date, '%a')

1
DAYNAME(orders.order_date)

See also

• Dates
• Other functions in Date parts: 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__HOUR_OF_DAY, KATER__MINUTE_OF_HOUR