Trigonometric Functions

1min

These trigonometric functions in Oxla take arguments and return values of type double precision and real.
Functions
Description
Syntax
Example
acos
It calculates the inverse cosine of a given argument, where the output is expressed in radians.
acos(argument)
select acos(1);
It will return:
 acos 
------
    0
acosd
It calculates the inverse cosine of a given argument, where the output is expressed in degrees.
acosd(argument)
select acosd(0.5);
It will return:
 acosd 
-------
    60
asin
It calculates the inverse sine of a given argument, where the output is expressed in radians.
asin(argument)
select asin(1);
It will return:
        asin        
-------------------
 1.5707963267948966
asind
It calculates the inverse sine of a given argument, where the output is expressed in degrees.
asind(argument)
select asind(0.5);
It will return:
 asind 
-------
    30
atan
It calculates the inverse tangent of a given argument, where the output is expressed in radians.
atan(argument)
select atan(1);
It will return:
   atan    
-----------
 0.7853965
atand
It calculates the inverse tangent of a given argument, where the output is expressed in degrees.
atand(argument)
select atand(1);
It will return:
       atand       
-------------------
 44.99990469434657
atan2
﻿
It calculates the inverse tangent of y/x, where the output is expressed in radians.
atan2(y_value, x_value)
y_value & x_value are in double precision type.
select atan2(1, 0);
It will return:
       atan2        
-------------------
 1.5707963267948966
atan2d
It calculates the inverse tangent of y/x, where the output is expressed in degrees.
atan2d(y_value, x_value)
y_value & x_value are in double precision type.
select atan2d(1, 0);
It will return:
 atan2d 
--------
     90
cos
It calculates the cosine of a given argument, where the argument is in radians.
cos(argument)
select cos(0);
It will return:
 cos 
-----
   1
cosd
It calculates the cosine of a given argument, where the argument is in degrees.
cosd(argument)
select cosd(60);
It will return:
        cosd        
-------------------
 0.5000000000000001
cot
It calculates the cotangent of a given argument, where the argument is in radians.
cot(argument)
select cot(0.5);
It will return:
   cot    
-----------
 1.8304877
cotd
It calculates the cotangent of a given argument, where the argument is in degrees.
cotd(argument)
select cotd(45);
It will return:
        cotd        
-------------------
 1.0000000000000002
sin
It calculates the sine of a given argument, where the argument is in radians.
sin(argument)
select sin(1);
It will return:
        sin         
-------------------
 0.8414709848078965
sind
It calculates the sine of a given argument, where the argument is in degrees.
sind(argument)
select sind(30);
It will return:
        sind         
-------------------
 0.49999999999999994
tan
It calculates the tangent of a given argument, where the argument is in radians.
tan(argument)
select tan(1);
It will return:
        tan         
-------------------
 1.5574077246549023
tand
It calculates the tangent of a given argument, where the argument is in degrees.
tand(argument)
select tand(45);
It will return:
        tand        
-------------------
 0.9999999999999999
﻿

Updated 14 Oct 2023

Did this page help you?

pg_typeof

Schema

Functions	Description	Syntax	Example
acos	It calculates the inverse cosine of a given argument, where the output is expressed in radians.	acos(argument)	select acos(1); It will return: acos ------ 0
acosd	It calculates the inverse cosine of a given argument, where the output is expressed in degrees.	acosd(argument)	select acosd(0.5); It will return: acosd ------- 60
asin	It calculates the inverse sine of a given argument, where the output is expressed in radians.	asin(argument)	select asin(1); It will return: asin ------------------- 1.5707963267948966
asind	It calculates the inverse sine of a given argument, where the output is expressed in degrees.	asind(argument)	select asind(0.5); It will return: asind ------- 30
atan	It calculates the inverse tangent of a given argument, where the output is expressed in radians.	atan(argument)	select atan(1); It will return: atan ----------- 0.7853965
atand	It calculates the inverse tangent of a given argument, where the output is expressed in degrees.	atand(argument)	select atand(1); It will return: atand ------------------- 44.99990469434657
atan2	It calculates the inverse tangent of y/x, where the output is expressed in radians.	atan2(y_value, x_value) y_value & x_value are in double precision type.	select atan2(1, 0); It will return: atan2 ------------------- 1.5707963267948966
atan2d	It calculates the inverse tangent of y/x, where the output is expressed in degrees.	atan2d(y_value, x_value) y_value & x_value are in double precision type.	select atan2d(1, 0); It will return: atan2d -------- 90
cos	It calculates the cosine of a given argument, where the argument is in radians.	cos(argument)	select cos(0); It will return: cos ----- 1
cosd	It calculates the cosine of a given argument, where the argument is in degrees.	cosd(argument)	select cosd(60); It will return: cosd ------------------- 0.5000000000000001
cot	It calculates the cotangent of a given argument, where the argument is in radians.	cot(argument)	select cot(0.5); It will return: cot ----------- 1.8304877
cotd	It calculates the cotangent of a given argument, where the argument is in degrees.	cotd(argument)	select cotd(45); It will return: cotd ------------------- 1.0000000000000002
sin	It calculates the sine of a given argument, where the argument is in radians.	sin(argument)	select sin(1); It will return: sin ------------------- 0.8414709848078965
sind	It calculates the sine of a given argument, where the argument is in degrees.	sind(argument)	select sind(30); It will return: sind ------------------- 0.49999999999999994
tan	It calculates the tangent of a given argument, where the argument is in radians.	tan(argument)	select tan(1); It will return: tan ------------------- 1.5574077246549023
tand	It calculates the tangent of a given argument, where the argument is in degrees.	tand(argument)	select tand(45); It will return: tand ------------------- 0.9999999999999999