SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xxiv
9. SQL/MX Functions and Expressions
Examples of INSERT 9-79
JULIANTIMESTAMP Function 9-80
Examples of JULIANTIMESTAMP 9-80
LASTNOTNULL Function 9-81
Examples of LASTNOTNULL 9-81
LCASE Function 9-82
Examples of LCASE 9-82
LEFT Function 9-83
Examples of LEFT 9-83
LNNVL Function 9-84
Examples of LNNVL 9-85
LOCATE Function 9-86
Considerations for LOCATE 9-87
Examples of LOCATE 9-87
LOG Function 9-88
Examples of LOG 9-88
LOG10 Function 9-88
Examples of LOG10 9-88
LOWER Function 9-89
Considerations for LOWER 9-89
Examples of LOWER 9-93
LPAD Function 9-94
Examples of LPAD 9-94
LTRIM Function 9-97
Considerations for LTRIM 9-97
Examples of LTRIM 9-97
MAX Function
9-98
Considerations for MAX 9-98
Examples of MAX 9-98
MIN Function
9-99
Considerations for MIN
9-99
Examples of MIN 9-99
MINUTE Function
9-100
Examples of MINUTE
9-100
MOD Function
9-101
Examples of MOD
9-101
MONTH Function 9-102
Examples of MONTH
9-102
MONTHNAME Function 9-103