SQL PHP HTML ASP JavaScript articles and free scripts to download
SQL Math Functions

abs functions

We can get absolute value by using abs function. This function takes one numeric input data. Here is an example

select abs(-2.3)

Output of above code is 2.3

select abs(+4.567)

Ouput is 4.567

select abs(0.23)

It is 0.23

Getting the sign of the number by using sign function

We can get the sign of the data by using sign function. Here is an example

select sign(-4.5); Output -1
select sign(+4.5); Output 1
select sign(4.5); Output 1

If we try a sting we will get 0 as output

select sign('abc'); // Output 0

What is the output of sign(0) ?

Be the first to post comment on this article :


Google+

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy




HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2015 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer