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

From Wikibooks, open books for an open world
< SQL Dialects Reference
Jump to: navigation, search

Trigonometric functions[edit]

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) N/A N/A  ? N/A N/A N/A N/A N/A N/A  ?