DuckDB function sign

Returns the sign of x as -1, 0 or 1.

Usage

sign(x)

Arguments

x

TINYINT | SMALLINT | INTEGER | BIGINT | HUGEINT | FLOAT | DOUBLE | UTINYINT | USMALLINT | UINTEGER | UBIGINT | UHUGEINT

Value

TINYINT

SQL examples

sign(-349)