SQL Dialects Reference/Functions and expressions/Math functions/Trigonometric functions
Appearance
Trigonometric functions
[edit | edit source]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 | ? |