ABS

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Applies to

• SQL Server

• Azure Synapse Analytics

Description

A mathematical function that returns the absolute (positive) value of the specified numeric expression. (ABS changes negative values to positive values. ABS has no effect on zero or positive values.) (ABS in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

ABS( expression )

Snowflake SQL

Snowflake SQL Documentation

ABS( <num_expr> )

JavaScript

JavaScript complete documentation

Math.abs( expression )

Examples

SQL Server

Code:

IN -> SqlServer_01.sql

SELECT ABS(-5);

Result:

ABS(-5)|
-------+
      5|

Snowflake SQL

Code:

OUT -> SqlServer_01.sql

SELECT ABS(-5);

Result:

ABS(-5)|
-------+
      5|

JavaScript

Code:

CREATE OR REPLACE FUNCTION compute_abs(a float)
  RETURNS float
  LANGUAGE JAVASCRIPT
AS
$$
  return Math.abs(A);
$$
;
SELECT COMPUTE_ABS(-5);

Result:

COMPUTE_ABS(-5)|
---------------+
              5|

Related Documentation

• Transact-SQL supported numeric types

Known Issues

No issues were found.

Related EWIs

No related EWIs.