Mathematic Functions
abs absolute value abs(-5) = 5
ceiling next highest int ceiling(5.3) = 6
floor next lowest int floor(5.7) = 5
power exponential power(2,8)=256
rand random number rand=0.315378 for example
round round to n places round(5.6,0)=6 round(5.66,1)=5.7
sign -1,0,1 sign(-5)=-1
Trigonometric and Log Functions
If you've advanced to the level where you're using trig operations within
a database, then you're probably not going to click on a link labeled
Sybase 101.
acos
asin
atan
atn2
cqos
cot
degrees
pi
radians
sin
exp exponential e
log log function
log10 log function base 10
|
|