BOOL
Syntax
BOOL( expression )Description
Converts the expression expression to Boolean type according to the following rules:
| Type | FALSE | TRUE |
|---|---|---|
Fractional number | Integer | 0, 0.0 | All others |
String | Empty string ("") | All others |
Boolean | FALSE | TRUE |
Date | Datetime | - | TRUE |
Argument types:
expression—Boolean | Date | Datetime | Fractional number | Geopoint | Geopolygon | Integer | String
Return type: Boolean
Examples
BOOL(0) = FALSEBOOL(#2019-04-04#) = TRUEBOOL("Lorem ipsum") = TRUEData source support
ClickHouse 21.8, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, YDB.