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