Greater than or equal

Greater-than-or-equal comparison.

Returns true when the left operand is greater than or equal to 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