Arithmetic Functions
Teradata supports the following arithmetic functions, which provide additional
functionality beyond ANSI SQL:
1)
ABS—absolute value
Example :
Abs(5) = 5
Abs(-3) = 3
2)
EXP—raises e to the power of <arg>
EXP(5) = 148.41
3)
LOG—base 10 logarithm
LOG(10) = 1
4) LN —natural logarithm
LN(10) = 2.30
5) SQRT—square root
SQRT(25) = 5
SQRT(100) = 10
No comments:
Post a Comment