Database Reference
In-Depth Information
Numeric Manipulation Functions
Numeric manipulation functions do just that—manipulate numeric data. These
functions tend to be used primarily for algebraic, trigonometric, or geometric
calculations and, therefore, are not as frequently used as string or date and time
manipulation functions.
The ironic thing is that of all the functions found in the major DBMSs, the
numeric functions are the ones that are most uniform and consistent. Table
11.3 lists some of the more commonly used numeric manipulation functions.
Table 11.3 Commonly Used Numeric Manipulation Functions
Function
Description
Abs()
Returns a number's absolute value
Cos()
Returns the trigonometric cosine of a specified angle
Exp()
Returns the exponential value of a specific number
Mod()
Returns the remainder of a division operation
Pi()
Returns the value of pi
Rand()
Returns a random number
Sin()
Returns the trigonometric sine of a specified angle
Sqrt()
Returns the square root of a specified number
Tan()
Returns the trigonometric tangent of a specified angle
Summary
In this chapter, you learned how to use SQL's data manipulation functions and
paid special attention to working with dates.
 
 
 
 
Search WWH ::




Custom Search