SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Contents
HP NonStop SQL/MX Reference Manual—640322-001
xxiii
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
EXTRACT Function 9-63
Examples of EXTRACT 9-63
FEATURE_VERSION_INFO Function 9-64
Input and Output Parameters 9-64
Example of FEATURE_VERSION_INFO 9-65
FLOOR Function 9-66
Examples of FLOOR 9-66
HASHPARTFUNC Function 9-67
Considerations for HashPartFunc 9-67
Examples of HashPartFunc 9-67
HOUR Function 9-71
Examples of HOUR 9-71
INSERT Function 9-72
Examples of INSERT 9-72
JULIANTIMESTAMP Function 9-73
Examples of JULIANTIMESTAMP 9-73
LASTNOTNULL Function 9-74
Examples of LASTNOTNULL 9-74
LCASE Function 9-75
Examples of LCASE 9-75
LEFT Function 9-76
Examples of LEFT 9-76
LOCATE Function 9-77
Considerations for LOCATE 9-77
Examples of LOCATE 9-78
LOG Function 9-79
Examples of LOG 9-79
LOG10 Function 9-79
Examples of LOG10 9-79
LOWER Function 9-80
Considerations for LOWER 9-80
Examples of LOWER 9-84
LPAD Function 9-85
Examples of LPAD 9-85
LTRIM Function 9-88
Considerations for LTRIM 9-88
Examples of LTRIM 9-88
MAX Function 9-89