Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

Informix Dynamic Server (IDS) Data Types - MONEY

Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x

Informix - MONEY
Syntax MONEY[(p[,s])]
Data Monetary data
Parameters p is the maximum number of all digits (both sides of the decimal point), s is the maximum number of digits after the decimal point
Range 1 ⇐ p ⇐ 32, 0 ⇐ s ⇐ p
Default p is 16, s is 2
Notes Client applications format MONEY values according to the locale. For example, for the US, $ is used as the currency symbol, a comma (,) is used as thousands separator and period (.) is used between the integer and fractional parts
Standards Informix SQL Extension

Example:

CREATE TABLE t_money (c1 MONEY);

Informix 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
SMALLMONEY, -214,748.3648 to 214,748.3647
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 MONEY, -922,337,203,685,477.5808 to 922,337,203,685,477.5807
SMALLMONEY, -214,748.3648 to 214,748.3647

Related Data Types in Informix

Data Types
Fixed-point DECIMAL(p,s) NUMERIC(p,s)

All Data Types


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

sqlways/informix/data-types/money.txt · Last modified: May 07, 2018, 03:15:26 PM (external edit)
 
© 1999-2021, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement