IMMEDIATELY PRECEDES | SQL Date/Time Functions & Expressions | Teradata Vantage - 17.10 - IMMEDIATELY PRECEDES - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Evaluates two Period expressions or derived periods.

Result Type

This predicate applies when both period_expression_1 and period_expression_2 are a period column, period constructor, or period value expression. In this case, the predicate returns True if the end bound value of period_expression_1 is equal to the begin bound value of period_expression_2. If either or both of the operands are NULL, the result is UNKNOWN.