KATER__YEAR

Family: Date grains

Syntax

1
KATER__YEAR(field)

Arguments

Returns

A date.

Usage notes

• On a timestamp, it drops the time of day too. So 14 March 2026 at 09:30 gives 1 January 2026.

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_year', KATER__YEAR(orders.order_date)) AS "Year"
5
FROM kater_dataset.orders AS orders
6
ORDER BY
7
  1
8
LIMIT 3

Compiles to

The call compiles to the same SQL on DuckDB and on Snowflake.

1
CAST(DATE_TRUNC('YEAR', orders.order_date) AS DATE)

See also

• Dates
• Other functions in Date grains: KATER__DATE, KATER__WEEK, KATER__MONTH, KATER__QUARTER, KATER__HOUR, KATER__MINUTE, KATER__SECOND, KATER__MILLISECOND