SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxxviii
8. SQL/MX Functions and Expressions
LOG10 Function 8-93
Examples of LOG10 8-93
LOWER Function 8-94
Considerations for LOWER 8-94
Examples of LOWER 8-98
LPAD Function 8-99
Examples of LPAD 8-99
LTRIM Function 8-102
Considerations for LTRIM 8-102
Result of LTRIM 8-102
Examples of LTRIM 8-102
MAX Function 8-103
Considerations for MAX 8-103
Operands of the Expression 8-103
Examples of MAX 8-103
MIN Function 8-104
Considerations for MIN 8-104
Operands of the Expression 8-104
Examples of MIN 8-104
MINUTE Function 8-105
Examples of MINUTE 8-105
MOD Function 8-106
Examples of MOD 8-106
MONTH Function 8-107
Examples of MONTH 8-107
MONTHNAME Function 8-108
Examples of MONTHNAME
8-108
MOVINGAVG Function 8-109
Examples of MOVINGAVG 8-110
MOVINGCOUNT Function
8-111
Considerations for MOVINGCOUNT
8-112
No DISTINCT Clause 8-112
Examples of MOVINGCOUNT
8-112
MOVINGMAX Function
8-113
Examples of MOVINGMAX
8-114
MOVINGMIN Function
8-115
Examples of MOVINGMIN 8-116
MOVINGSTDDEV Function
8-117
Examples of MOVINGSTDDEV 8-118