Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial

SQL Server Data Types - SMALLMONEY

Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5

SQL Server - SMALLMONEY
Syntax SMALLMONEY
Data Monetary data
Range -214,748.3648 to 214,748.3647
Storage Size 4 bytes
Standards SQL Server Extension

SQL Server SMALLMONEY - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(p,s), 1 ⇐ p ⇐ 38, -84 ⇐ s ⇐ 127
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
Sybase ASE SMALLMONEY, -214,748.3648 to 214,748.3647
Informix MONEY(p,s), 1 ⇐ p ⇐ 32, 0 ⇐ s ⇐ p

Related Data Types in SQL Server

Data Types
Monetary data MONEY
Decimal data DECIMAL(p,s) NUMERIC(p,s)

All Data Types


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