Function
|
Oracle
|
SQL Server
|
Absolute Value
|
ABS(p)
|
ABS(p)
|
Arc Cosine
|
ACOS(p)
|
ACOS(p)
|
Arc Sine
|
ASIN(p)
|
ASIN(p)
|
Arc Tangent
|
ATAN(p)
|
ATAN(p)
|
Arc Tangent of n and m
|
ATAN2(p1, p2)
|
ATN2(p1, p2)
|
Smallest Integer Greater Than or Equal to Input Value
|
CEIL(p)
|
CEILING(p)
|
Cosine
|
COS(p)
|
COS(p)
|
Hyperbolic Cosine
|
COSH(p)
|
COT(p)
|
E Raised to the nth Power
|
EXP(p)
|
EXP(p)
|
Largest Integer Value Less Than or Equal to Input Value
|
FLOOR(p)
|
FLOOR(p)
|
Natural Logarithm
|
LN(p)
|
LOG(p)
|
Logarithm of n Base m
|
LOG(m, n)
|
LOG(p1, p2)
|
Logarithm, Base 10
|
LOG(10, p)
|
LOG10(p)
|
Modulus
|
MOD(p1, p2)
|
p1 % p2
|
Power
|
POWER(p1, p2)
|
POWER(p1, p2)
|
Random Number
|
Not Applicable
|
RAND()
|
Remainder
|
REMAINDER(p1, p2)
|
Not Available
|
Round
|
ROUND(p1, p2)
|
ROUND(p1, p2)
|
Sign of Number
|
SIGN(p)
|
SIGN(p)
|
Sine
|
SIN(p)
|
SIN(p)
|
Hyberbolic Sine
|
SINH(p)
|
Not Available
|
Square Root
|
SQRT(p)
|
SQRT(p)
|
Tangent
|
TAN(p)
|
TAN(p)
|
Hyberbolic Tangent
|
TANH(p)
|
Not Available
|
Truncate
|
TRUNC(p1, p2)
|
ROUND(p1, p2, 1)
|
Greatest Value in a List of Expressions
|
GREATEST(p1, p2, …, pn)
|
Not Available
|
Smallest Value in a List of Expressions
|
LEAST(p1, p2, …, pn)
|
Not Available
|
Convert Number if NULL
|
NVL(p1, p2)
|
ISNULL(p1, p2)
|
|