Reference Manual
   CHAPTER 7. SQL Data Types     

Money data types

Function 

For storing monetary data.

  MONEY data type [Money]

Function 

This data type is convenient for storing monetary data, and provides compatibility with the Adaptive Server Enterprise MONEY data type.

Syntax 

MONEY

Usage 

The MONEY data type is implemented as NUMERIC(19,4), allowing NULL.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Monetary data types in Adaptive Server Anywhere are implemented as user-defined data types, and are primarily intended for compatibility with Adaptive Server Enterprise.

See also 

SMALLMONEY data type

  SMALLMONEY data type [Money]

Function 

The data type is convenient for storing monetary data that is not too large, and provides compatibility with the Adaptive Server Enterprise SMALLMONEY data type.

Syntax 

SMALLMONEY

Usage 

The SMALLMONEY data type is implemented in Adaptive Server Anywhere as a user-defined data type, as NUMERIC(10,4), allowing NULL.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Monetary data types in Adaptive Server Anywhere are implemented as user-defined data types, and are primarily intended for compatibility with Adaptive Server Enterprise.

See also 

MONEY data type