LESS_THAN
All functions > COMPARISON > LESS_THAN
Returns TRUE if the first value is strictly less than the second value
Signatures
Returns: TRUE if expr1 < expr2, FALSE otherwise, NULL if either value is NULL
LESS_THAN(expr1: T, expr2: T, [digits: BIGINT]) → BOOLEANsql
| Parameter | Type | Required | Description |
|---|---|---|---|
expr1 | T | Yes | First value to compare |
expr2 | T | Yes | Second value to compare |
digits | BIGINT | No | Optional decimal precision for numeric comparisons |
Notes
- Both values must be of comparable types
- NULL comparisons always return NULL (three-valued logic)
- For strings, uses lexicographic (dictionary) ordering
- For dates/timestamps, earlier dates are "less than" later dates
- Supports optional decimal precision for numeric comparisons
See also
On this page