Skip to main content
DocumentationLibraryReference
On this page

Kater SQL Functions Date conditions

KATER__IS_ON

True where the date is the value.

Family: Date conditions

Syntax 

KATER__IS_ON(field, value)

Arguments

ArgumentDescription
fieldThe date or timestamp to test.
valueThe value to compare with. A value, or a parameter a reader supplies.

Returns

TRUE or FALSE. It is NULL where the field is empty, so a filter leaves that row out.

Usage notes

  • On a timestamp, it matches one exact instant, not a whole day. To match a day, test KATER__DATE(field).

Example

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

SELECT
  orders.order_date AS "Order Date",
  EVAL(orders.count_distinct__order_id) AS "Orders"
FROM kater_dataset.orders AS orders
WHERE
  KATER__IS_ON(orders.order_date, DATE '2026-09-30')
GROUP BY
  orders.order_date
ORDER BY
  1
Order DateOrders
2026-09-302

Compiles to

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

orders.order_date = CAST('2026-09-30' AS DATE)

See also