Returns a number that indicates the sign of a numeric value expression.
| Category: | Mathematical |
| Returned data type: | TINYINT |
| Note: | This function is not supported on Teradata 14.0. and later. |
specifies any valid SQL expression that evaluates to a numeric value.
| Data type | BIGINT, DOUBLE, FLOAT, INTEGER, REAL, SMALLINT, TINYINT |
| See | <sql-expression> |
| FedSQL Expressions |
|
Statements
|
Results
|
|---|---|
select sign(-5); |
-1 |
select sign(5); |
1 |
select sign(0); |
0 |