SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Reference Manual—523725-004
xxi
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
DEGREES Function 9-48
Examples of DEGREES 9-48
DIFF1 Function 9-49
Considerations for DIFF1 9-49
Examples of DIFF1 9-50
DIFF2 Function 9-52
Considerations for DIFF2 9-52
Examples of DIFF2 9-53
EXP Function 9-55
Examples of EXP 9-55
EXPLAIN Function 9-55
Considerations for EXPLAIN 9-56
Examples of EXPLAIN 9-59
EXTRACT Function 9-62
Examples of EXTRACT 9-62
FLOOR Function 9-63
Examples of FLOOR 9-63
HOUR Function 9-64
Examples of HOUR 9-64
INSERT Function 9-65
Examples of INSERT 9-65
JULIANTIMESTAMP Function 9-66
Examples of JULIANTIMESTAMP 9-66
LASTNOTNULL Function 9-67
Examples of LASTNOTNULL 9-67
LCASE Function 9-68
Examples of LCASE 9-68
LEFT Function 9-69
Examples of LEFT 9-69
LOCATE Function 9-70
Considerations for LOCATE 9-70
Examples of LOCATE 9-71
LOG Function 9-72
Examples of LOG 9-72
LOG10 Function 9-73
Examples of LOG10 9-73
LOWER Function 9-74
Considerations for LOWER 9-74