Categories:: Period functions

PERIOD_SUCCEEDS¶

Returns TRUE if the first PERIOD begins at or after the second PERIOD ends.

See also:: PERIOD data type , Period functions

Syntax¶

PERIOD_SUCCEEDS( <period1>, <period2> )

Arguments¶

period1: The first PERIOD value.

period2: The second PERIOD value. Must have the same element type as period1.

Returns¶

BOOLEAN.

Usage notes¶

TRUE when PERIOD_BEGIN(period1) >= PERIOD_END(period2).

Examples¶

This example shows a period that succeeds another (it begins at or after the second ends), and one that doesn’t:

WITH periods AS (
  SELECT
    PERIOD(DATE) '[2024-01-01, 2024-04-01)' AS p_left,
    PERIOD(DATE) '[2024-04-01, 2024-07-01)' AS p_right
)
SELECT
    PERIOD_SUCCEEDS(p_right, p_left) AS succeeds_true,
    PERIOD_SUCCEEDS(p_left, p_right) AS succeeds_false
  FROM periods;

+---------------+----------------+
| SUCCEEDS_TRUE | SUCCEEDS_FALSE |
|---------------+----------------|
| True          | False          |
+---------------+----------------+