Sybase Adaptive Server Anywhere - Money Data Types

Chapter 7 SQL Data Types
275
Money data types
For storing monetary data.
MONEY data type [Money]
This data type is convenient for storing monetary data, and provides
compatibility with the Adaptive Server Enterprise MONEY data type.
MONEY
The MONEY data type is implemented as a domain, as NUMERIC(19,4),
allowing NULL.
♦
SQL/92 Vendor extension.
♦
Sybase Monetary data types in Adaptive Server Anywhere are
implemented as domains, and are primarily intended for compatibility
with Adaptive Server Enterprise.
"SMALLMONEY data type" on page 275
SMALLMONEY data type [Money]
This data type is convenient for storing monetary data that is not too large,
and provides compatibility with the Adaptive Server Enterprise
SMALLMONEY data type.
SMALLMONEY
The SMALLMONEY data type is implemented in Adaptive Server
Anywhere as a domain, as NUMERIC(10,4), allowing NULL.
♦
SQL/92 Vendor extension.
♦
Sybase Monetary data types in Adaptive Server Anywhere are
implemented as domains, and are primarily intended for compatibility
with Adaptive Server Enterprise.
"MONEY data type" on page 275
Function
Function
Syntax
Usage
Standards and
compatibility
See also
Function
Syntax
Usage
Standards and
compatibility
See also