Table of Contents
Ispirer Website
Ispirer Capabilities - PostgreSQL Migration
Free Trial
PostgreSQL - SQL Functions Mapping to Other Databases
Numeric Functions Mapping
| PostgreSQL | Oracle | SQL Server | IBM DB2 | MySQL |
|---|---|---|---|---|
| ABS | ABS | ABS | ABS | ABS |
| ACOS | ACOS | ACOS | ACOS | ACOS |
| ASIN | ASIN | ASIN | ASIN | ASIN |
| ATAN | ATAN | ATAN | ATAN | ATAN |
| ATAN2 | ATAN2 | ATN2 | ATAN2 | ATAN2 |
| CBRT | ||||
| CEIL | CEIL | CEILING | CEILING | CEILING |
| COS | COS | COS | COS | COS |
| COT | COT | COT | COT | |
| DEGREES | DEGREES | DEGREES | DEGREES | |
| DIV | DIV | |||
| EXP | EXP | EXP | EXP | EXP |
| FLOOR | FLOOR | FLOOR | FLOOR | FLOOR |
| LN | LN | LOG | LN | LN |
| LOG | LOG | LOG10 | LOG10 | LOG10 |
| MOD | MOD | MOD | MOD | |
| PI | PI | PI | ||
| POWER | POWER | POWER | POWER | POWER |
| RADIANS | RADIANS | RADIANS | RADIANS | |
| RANDOM | RAND | RAND | RAND | |
| ROUND | ROUND (number) | ROUND | ROUND | ROUND |
| SIGN | SIGN | SIGN | SIGN | SIGN |
| SIN | SIN | SIN | SIN | SIN |
| SQRT | SQRT | SQRT | SQRT | SQRT |
| TAN | TAN | TAN | TAN | TAN |
| TRUNC | TRUNC (number) | TRUNCATE | TRUNCATE |