Less than

Less-than comparison.

Returns true when the left operand is less than the right operand.

Category: comparison

SQL symbol: <

Example

SELECT DATE '2024-01-01' < DATE '2024-01-01';

Signatures

• blob < blob → boolean
• blob < varchar → boolean
• date < date → boolean
• date < integer → boolean
• date < timestamp → boolean
• decimal < decimal → boolean
• decimal < double → boolean
• decimal < integer → boolean
• double < decimal → boolean
• double < double → boolean
• double < integer → boolean
• integer < date → boolean
• integer < decimal → boolean
• integer < double → boolean
• integer < integer → boolean
• integer < timestamp → boolean
• interval < interval → boolean
• timestamp < date → boolean
• timestamp < integer → boolean
• timestamp < timestamp → boolean
• varchar < blob → boolean
• varchar < varchar → boolean

Types

• Left: blob, date, decimal, double, integer, interval, timestamp, varchar
• Right: blob, date, decimal, double, integer, interval, timestamp, varchar
• Result: boolean