SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xxiv
9. SQL/MX Functions and Expressions
Examples of DAYOFMONTH 9-52
DAYOFWEEK Function 9-53
Examples of DAYOFWEEK 9-53
DAYOFYEAR Function 9-54
Examples of DAYOFYEAR 9-54
DECODE Function 9-55
Considerations 9-55
Examples of DECODE 9-57
DEGREES Function 9-57
Examples of DEGREES 9-57
DIFF1 Function 9-59
Considerations for DIFF1 9-59
Examples of DIFF1 9-60
DIFF2 Function 9-62
Considerations for DIFF2 9-62
Examples of DIFF2 9-63
EXP Function 9-65
Examples of EXP 9-65
EXPLAIN Function 9-66
Considerations for EXPLAIN 9-67
Examples of EXPLAIN 9-72
EXTRACT Function 9-75
Examples of EXTRACT 9-75
FEATURE_VERSION_INFO Function 9-76
Input and Output Parameters 9-76
Example of FEATURE_VERSION_INFO 9-77
FLOOR Function
9-78
Examples of FLOOR 9-78
HASHPARTFUNC Function 9-79
Considerations for HashPartFunc
9-79
Examples of HashPartFunc
9-79
HOUR Function 9-83
Examples of HOUR
9-83
INSERT Function
9-84
Examples of INSERT
9-84
JULIANTIMESTAMP Function
9-85
Examples of JULIANTIMESTAMP 9-85
LASTNOTNULL Function
9-86
Examples of LASTNOTNULL 9-86