Jump to content

SQL Dialects Reference/Functions and expressions/Math functions/Trigonometric functions

From Wikibooks, open books for an open world

Trigonometric functions

[edit | edit source]

This page includes comparison tables which can be big and complex.

While it's perfectly all right to view them in their complete state, it is recommended to install a comparison tables extension that would allow to select particular columns of interest for comparison.

SQL version Feature Standard
SQL:2011
DB2 Firebird Ingres Linter MSSQL MySQL
Vers. 5.x
MonetDB Oracle
Vers. 11.x
PostgreSQL SQLite Virtuoso
? Arc sine N/A ASIN(x) ASIN(x) ASIN(X) ASIN(x) ASIN(x) ASIN(x) ASIN(x) ASIN(x) ASIN(x) N/A ASIN(x)
? Arc cosine N/A ACOS(x) ACOS(x) ACOS(x) ACOS(x) ACOS(x) ACOS(x) ACOS(x) ACOS(x) ACOS(x) N/A ACOS(x)
? Arc tangent of x N/A ATAN(x) ATAN(x) ATAN(x) ATAN(x) ATAN(x) ATAN(x) ATAN(x) ATAN(x) ATAN(x) N/A ATAN(x)
? Arc tangent of x and y N/A ATAN2(x, y) ATAN2(x,y) ATAN2(x, y) ATAN2(x, y) ATN2(x, y) ATAN2(x, y)
ATAN(x, y)
ATAN2(x,y) ATAN2(x, y)
ATAN2(x / y)
ATAN2(x,y) N/A ATAN2(x, y)
? Sine N/A SIN(x) SIN(x) SIN(x) SIN(x) SIN(x) SIN(x) SIN(x) SIN(x) SIN(x) N/A SIN(x)
? Cosine N/A COS(x) COS(x) COS(x) COS(x) COS(x) COS(x) COS(x) COS(x) COS(x) N/A COS(x)
? Tangent N/A TAN(x) TAN(x) TAN(x) TAN(x) TAN(x) TAN(x) TAN(x) TAN(x) TAN(x) N/A TAN(x)
? Cotangent N/A COT(x) COT(x) N/A N/A COT(x) COT(x) COT(x) N/A COT(x) N/A COT(x)
? Hyperbolic sine N/A SINH(x) SINH(x) N/A SINH(x) N/A N/A SINH(x) SINH(x) N/A N/A N/A
? Hyperbolic cosine N/A COSH(x) COSH(x) N/A COSH(x) N/A N/A COSH(x) COSH(x) N/A N/A N/A
? Hyperbolic tangent N/A TANH(x) TANH(x) N/A TANH(x) N/A N/A TANH(x) TANH(x) N/A N/A N/A
? Hyperbolic arctangent N/A ATANH(x) ATANH(x) N/A ? N/A N/A N/A N/A N/A N/A ?