<
(lt sign) operator
Applies to: Databricks SQL Databricks Runtime
Returns true
if expr1
is less than expr2
, or false
otherwise.
Syntax
expr1 < expr2
Arguments
expr1
: An expression of any comparable type.expr2
: An expression that shares a least common type withexpr1
.
Returns
A BOOLEAN.
Examples
> SELECT 1 < 2;
true
> SELECT 1.1 < '1';
false
> SELECT to_date('2009-07-30 04:17:52') < to_date('2009-07-30 04:17:52');
false
> SELECT to_date('2009-07-30 04:17:52') < to_date('2009-08-01 04:17:52');
true
> SELECT 1 < NULL;
NULL