Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column where a result of 5 is 5 but -5 is also
5, so in effect all the negative (and only the negative) results are made positive to
find the deviation from zero.
so
5, 4, -3, 4, -1,
abs()
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 01, 2004 12:59 PM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column where
Found answer to my own question:
Returns the absolute value of X:
mysql SELECT ABS(2);
- 2
mysql SELECT ABS(-32);
- 32
This function is safe to use with BIGINT values.
MySQL Reference Manual (C) 2002 MySQL AB
[EMAIL PROTECTED] wrote on 01/09/2004 11:59:58:
is there a function to make negative
numbers positive?
ABS(x)
See http://dev.mysql.com/doc/mysql/en/Mathematical_functions.html
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
ABS(column) ?
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 01, 2004 6:59 AM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column
[EMAIL PROTECTED] wrote:
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column where a result of 5 is 5
but -5 is also 5, so in effect all the negative (and only the negative)
results are made positive to find the deviation from
