BETWEEN

Syntax

value [ NOT ] BETWEEN low AND high

Description

Returns TRUE if value is in the range from low to high inclusive.

The option value NOT BETWEEN low AND high returns the opposite value.

Argument types:

  • value — Date | Datetime | Fractional number | Integer | String
  • low — Date | Datetime | Fractional number | Integer | String
  • high — Date | Datetime | Fractional number | Integer | String

Return type: Boolean

Note

Arguments value, low, high must be of the same type.

Examples

3 BETWEEN 1 AND 100 = TRUE
        
100 BETWEEN 1 AND 100 = TRUE
        
3 NOT BETWEEN 1 AND 100 = FALSE
        
#2018-01-12# BETWEEN #2018-01-10# AND #2018-01-15# = TRUE
        
#2018-01-12 01:02:10# BETWEEN #2018-01-12 01:02:00# AND #2018-01-12 01:02:30# = TRUE

Data source support

ClickHouse 21.8, Files, Google Sheets, Yandex Metrica, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Yandex Documents, YDB.

Previous
Addition and concatenation (+)
Next
Comparison