Differences

This shows you the differences between two versions of the page.

--- dev:sql:functions:abs [2010/07/04 02:15]
tdo
+++ dev:sql:functions:abs [2016/06/28 22:38] (current)
@@ Line 1: / Line 1: @@
 {{page>:top_add&nofooter&noeditbtn}}
-<html><div align="center"><span style="color:red">DRAFT</span></div></html>
-====== Omnidex SQL Function: ABS ======
 {{page>:sql_bar&nofooter&noeditbtn}}
+====== Omnidex SQL Function: ABS ======
 ===== Description =====
-The ABS function returns the absolute value of column.  The return data_type is the same as the data type of the numeric_expression.  The numeric_expression can be a column_spec or a set of functions and operators that yield a numeric expression.
+The ABS function returns the absolute value of column.
+This function returns the same datatype as the passed parameter.
 ===== Syntax =====
-  ABS(numeric-expression)
+  ABS( numeric_expression )
+== numeric_expression ==
+Required.  Any expression that returns a numeric-class datatype.
 ===== Examples =====
-  select abs(col1) from trans_table;
+=== Example 1: Column ===
+<code>
+> select longitude, abs(longitude) from countries;
+LONGITUDE                         ABS(LONGITUDE)
+--------------------------------  --------------------------------
+-176.199997                       176.199997
+-175.000000                       175.000000
+-172.330002                       172.330002
+-171.750000                       171.750000
+-170.699997                       170.699997
+-170.000000                       170.000000
+-169.860001                       169.860001
+</code>
+====== Additional Resources ======
+See also:
+{{page>dev:sql:functions:see_also_math&noheader&nofooter&noeditbtn}}
 {{page>:bottom_add&nofooter&noeditbtn}}

Back to top

dev/sql/functions/abs.1278209737.txt.gz · Last modified: 2016/06/28 22:38 (external edit)

Sitemap Recent Changes