Website logo
⌘K
šŸ Homepage
šŸ‘‹Introduction
Key Concepts & Architecture
šŸš€Run Oxla in 2 minutes
šŸƒā€ā™‚ļøRun Oxla on S3
šŸ›«Multi-node Deployment
šŸ‘Øā€šŸ’»SQL Reference
SQL Queries
SQL Clauses
SQL Data Types
SQL Functions
Schema
Comment Support
ā›“ļøSQL Mutations
DELETE
UPDATE
🚨Error Handling
šŸ†šDifferences Between Oxla vs. PostgreSQL
šŸ”„Understanding Transactions
šŸ“ˆPublic Metrics
āš™ļøOxla Configuration File
✨Changelog
Docs powered byĀ Archbee
SQL Reference
SQL Functions

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?
PREVIOUS
pg_typeof
NEXT
Schema
Docs powered byĀ Archbee
Docs powered byĀ Archbee

©2023 Oxla