Intrinsic Function Examples

You can use Intrinsic Functions to perform several different kinds of arithmetic as outlined in the table below:

Table 1. Types of Arithmetic that Numeric Functions Handle
Number Handling	Date/Time	Finance	Mathematics	Statistics
LENGTH MAX MIN NUMVAL NUMVAL-C ORD-MAX ORD-MIN	CURRENT-DATE DATE-OF-INTEGER DAY-TO-YYYYDDD DATE-TO-YYYYMM DD DAY-OF-INTEGER EXTRACT-DATE- TIME FIND-DURATION INTEGER-OF-DATE INTEGER-OF-DAY WHEN-COMPILED YEAR-TO-YYYY	ANNUITY PRESENT -VALUE	ACOS ASIN ATAN COS FACTORIAL INTEGER INTEGER-PART LOG LOG10 MOD REM SIN SQRT SUM TAN	MEAN MEDIAN MIDRANGE RANDOM RANGE STANDARD -DEVIATION VARIANCE

The following examples and accompanying explanations show intrinsic functions in each of the categories listed in the preceding table.