SIGN
Returns the sign of the argument as -1, 0, or 1, depending on whether x is negative, zero, or positive or NULL if the argument was NULL.
Analyze Syntax
func.sign( <x> )
Analyze Examples
func.sign(0)
┌──────────────┐
│ func.sign(0) │
├──────────────┤
│ 0 │
└──────────────┘
SQL Syntax
SIGN( <x> )
SQL Examples
SELECT SIGN(0);
┌─────────┐
│ sign(0) │
├─────────┤
│ 0 │
└─────────┘
Last modified April 23, 2024 at 12:42 PM EST: updating numerical functions (2a94341)