Ispirer Website
Ispirer Capabilities - Sybase Migration
Free Trial
Sybase ASE Data Types - MONEY
Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x
| Sybase ASE - MONEY | |
|---|---|
| Syntax | MONEY |
| Data | Monetary data |
| Range | -922,337,203,685,477.5808 to 922,337,203,685,477.5807 |
| Storage Size | 8 bytes |
| Standards | Sybase Transact-SQL Extension |
Sybase ASE MONEY - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Oracle | NUMBER(p,s), 1 ⇐ p ⇐ 38, -84 ⇐ s ⇐ 127 |
| SQL Server | MONEY, -922,337,203,685,477.5808 to 922,337,203,685,477.5807 |
| MySQL | DECIMAL(p,s), NUMERIC(p,s), 1 ⇐ p ⇐ 65, 0 ⇐ s ⇐ 30 |
| PostgreSQL | MONEY, -92,233,720,368,547,758.08 to 92,233,720,368,547,758.07 |
| Informix | MONEY(p,s), 1 ⇐ p ⇐ 32, 0 ⇐ s ⇐ p |
Related Data Types in Sybase ASE
| Data Types | ||
|---|---|---|
| Monetary data | SMALLMONEY | |
| Decimal data | DECIMAL(p,s) | NUMERIC(p,s) |
All Data Types