Functions can be categorized by the types
of values that they operate on. Each FedSQL function belongs to one
of the following categories:
Aggregate
operates on the values
in a table column
Bitwise Logical Operations
operates on one or
more bit patterns or binary numbers at the level of their individual
bits
Character
operates on character
SQL expressions
Date and Time
operates on date and
time SQL expressions
Descriptive Statistics
operates on values
that measure central tendency, variation among values, and the shape
of distribution values
Financial
calculates financial
values such as interest, periodic payments, depreciation, and prices
for European options on stocks.
Mathematical
operates on values
to perform general mathematical calculations
Probability
returns probability
calculations.
Special
operates on null values
and SAS missing values
Trigonometric
operates on values
to perform trigonometric calculations
Truncation
truncates numeric values
and returns numeric values, often using fuzzing