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 |