BETWEEN and OVERLAPS Predicates
Abstract
The BETWEEN and OVERLAPS predicates both offer a shorthand way of showing that one value lies within a range defined by two other values. BETWEEN works with scalar range limits of any type; the OVERLAPS predicate looks at two time periods.
Keywords
BETWEEN
OVERLAPS
SYMMETRIC
ASYMMETRIC
NULLs
INTERVAL
The between and OVERLAPS predicates both offer a shorthand way of showing that one value lies within a range defined by two other values. BETWEEN works with scalar range limits of any type; the OVERLAPS predicate looks at two time periods (defined either by start and end points or by a starting time and an INTERVAL) to see if they overlap in time.
19.1 The BETWEEN Predicate
The BETWEEN predicate ...
Get Joe Celko's SQL for Smarties, 5th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
