Wikibooks

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

< SQL Dialects Reference
This page may need to be reviewed for quality.

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) ATANH(x) N/A ? N/A N/A N/A N/A N/A N/A ?
Retrieved from "https://en.wikibooks.org/wiki/SQL_Dialects_Reference/Functions_and_expressions/Math_functions/Trigonometric_functions"