Mathematical functions return values commonly needed for operations on mathematical data. Mathematical function names are not keywords.
Each function also accepts arguments that can be implicitly converted to the specified type. For example, functions that accept approximate numeric types also accept integer types. SAP ASE automatically converts the argument to the desired type
|
Function |
ASE |
ASA |
ASIQ |
dir_con |
|---|---|---|---|---|
|
abs |
Y |
Y |
Y |
C |
|
acos |
Y |
Y |
N |
C |
|
asin |
Y |
Y |
N |
C |
|
atan |
Y |
Y |
N |
C |
|
atn2 |
Y |
Y |
N |
C |
|
ceiling |
Y |
Y |
Y |
C |
|
cos |
Y |
Y |
N |
C |
|
cot |
Y |
Y |
N |
C |
|
degrees |
Y |
Y |
N |
C |
|
exp |
Y |
Y |
N |
C |
|
floor |
Y |
Y |
Y |
C |
|
log |
Y |
Y |
N |
C |
|
log10 |
Y |
Y |
N |
C |
|
pi |
Y |
Y |
N |
C |
|
power |
Y |
Y |
N |
C |
|
radians |
Y |
Y |
N |
C |
|
rand |
Y |
Y |
Y |
C |
|
round |
Y |
Y |
N |
C |
|
sign |
Y |
Y |
N |
C |
|
sin |
Y |
Y |
N |
C |
|
sqrt |
Y |
Y |
Y |
C |
|
tan |
Y |
Y |
N |
C |