SQL/MX 2.x Reference Manual (H06.04+)

Contents
HP NonStop SQL/MX Reference Manual—540440-003
xxi
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
Examples of DIFF1 9-46
DIFF2 Function 9-48
Considerations for DIFF2 9-48
Examples of DIFF2 9-49
EXP Function 9-51
Examples of EXP 9-51
EXPLAIN Function 9-52
Considerations for EXPLAIN 9-53
Examples of EXPLAIN 9-56
EXTRACT Function 9-59
Examples of EXTRACT 9-59
FLOOR Function 9-60
Examples of FLOOR 9-60
HASHPARTFUNC Function 9-61
Considerations for HashPartFunc 9-61
Examples of HashPartFunc 9-61
HOUR Function 9-65
Examples of HOUR 9-65
INSERT Function 9-66
Examples of INSERT 9-66
JULIANTIMESTAMP Function 9-67
Examples of JULIANTIMESTAMP 9-67
LASTNOTNULL Function 9-68
Examples of LASTNOTNULL 9-68
LCASE Function 9-69
Examples of LCASE 9-69
LEFT Function 9-70
Examples of LEFT 9-70
LOCATE Function 9-71
Considerations for LOCATE 9-71
Examples of LOCATE 9-72
LOG Function 9-73
Examples of LOG 9-73
LOG10 Function 9-73
Examples of LOG10 9-73
LOWER Function 9-74
Considerations for LOWER 9-74
Examples of LOWER 9-78