|
Mathematical Functions
The mathematical functions of
ASE®
can be used to calculate mathematical data.
The names of the mathematical functions are not treated as
keywords.
Usage of Mathematical Functions
For all mathematical functions, values can be declared. These will then automatically be converted into the respective required
datatype
using
implicit conversion.
Thus, if a function expects a datatype
approximate numeric
it can still be declared with
integer
datatypes. ASE® automatically converts the values into the required datatypes.
See also:
Compatability Table Datatype Conversion.
List of ASE Mathematical Functions
ASE®
provides a number of mathematical functions:
-
abs(),
-
acos(),
-
asin(),
-
atan(),
-
atn2(),
-
ceiling(),
-
cos(),
-
cot(),
-
degrees(),
-
exp(),
-
floor(),
-
log(),
-
log10(),
-
pi(),
-
power(),
-
radiants(),
-
rand(),
-
round(),
-
sign(),
-
sin(),
-
sqrt(),
-
tan()
See also:
ASE T-SQL - Aggregate Functions,
abs(),
acos(),
asin(),
atan(),
atn2(),
ceiling(),
cos(),
cot(),
degrees(),
exp(),
floor(),
log(),
log10(),
pi(),
power(),
radians(),
rand(),
round(),
sign(),
sin(),
sqrt(),
tan().
|
