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


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.