Approximate numeric datatypes  Date and time datatypes

Chapter 6: Using and Creating Datatypes

Money datatypes

The money datatypes, money and smallmoney, store monetary data. You can use these datatypes for U.S. dollars and other decimal currencies, although Adaptive Server provides no means to convert from one currency to another. You can use all arithmetic operations except modulo, and all aggregate functions, with money and smallmoney data.

Both money and smallmoney are accurate to one ten-thousandth of a monetary unit, but round values up to two decimal places for display purposes. The default print format places a comma after every three digits.





Copyright © 2005. Sybase Inc. All rights reserved. Date and time datatypes

View this book as PDF