Page History
...
Calculates the arc tangent.
Example
| Code Block |
|---|
SELECT ATAN(D) FROM Employee |
...
COS, COSH
COS returns the trigonometric cosine whereas COSH returns the hyperbolic cosine.
Example
| Code Block |
|---|
SELECT COS(ANGLE) FROM Employee |
...
Example
| Code Block |
|---|
SELECT COSH(X) FROM Employee |
...
COT
Calculates the trigonometric cotangent.
Example
| Code Block |
|---|
SELECT COT(ANGLE) FROM Employee |
...
SIN, SINH
SIN returns the trigonometric sine whereas SINH returns the hyperbolic sine.
Example
| Code Block |
|---|
SELECT SIN(ANGLE) FROM Employee |
...
Example
| Code Block |
|---|
SELECT SINH(ANGLE) FROM Employee |
...
TAN, TANH
TAN calculates the trigonometric tangent whereas TANH calculates the hyperbolic tangent.
Example
| Code Block |
|---|
SELECT TAN(ANGLE) FROM Employee |
...
Example
| Code Block |
|---|
SELECT TANH(X) FROM Employee |
...
ATAN2
Calculates the angle when converting the rectangular coordinates to polar coordinates.
Example
| Code Block |
|---|
SELECT ATAN2(X,Y) FROM Employee |
...
MOD
The modulo operation. This method returns a long.
Example
| Code Block |
|---|
SELECT MOD(Salary, Deduction) FROM Employee |
...
CEILING
Returns the smallest integer greater than or equal to the specified numeric expression.
Example
| Code Block |
|---|
SELECT CEILING(Salary), CEILING(123.45), CEILING(0.0) FROM Employee |
...
DEGREES
Converts an angle measured in radians to an approximately equivalent angle measured in degrees.
...