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

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xxiii
9. SQL/MX Functions and Expressions
DAY Function 9-45
Examples of DAY 9-45
DAYNAME Function 9-46
Examples of DAYNAME 9-46
DAYOFMONTH Function 9-47
Examples of DAYOFMONTH 9-47
DAYOFWEEK Function 9-48
Examples of DAYOFWEEK 9-48
DAYOFYEAR Function 9-49
Examples of DAYOFYEAR 9-49
DECODE Function 9-50
Considerations 9-50
Examples of DECODE 9-52
DEGREES Function 9-52
Examples of DEGREES 9-52
DIFF1 Function 9-54
Considerations for DIFF1 9-54
Examples of DIFF1 9-55
DIFF2 Function 9-57
Considerations for DIFF2 9-57
Examples of DIFF2 9-58
EXP Function 9-60
Examples of EXP 9-60
EXPLAIN Function 9-61
Considerations for EXPLAIN 9-62
Examples of EXPLAIN 9-67
EXTRACT Function
9-70
Examples of EXTRACT 9-70
FEATURE_VERSION_INFO Function 9-71
Input and Output Parameters
9-71
Example of FEATURE_VERSION_INFO
9-72
FLOOR Function 9-73
Examples of FLOOR
9-73
HASHPARTFUNC Function
9-74
Considerations for HashPartFunc
9-74
Examples of HashPartFunc
9-74
HOUR Function 9-78
Examples of HOUR
9-78
INSERT Function 9-79