SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxxvi
8. SQL/MX Functions and Expressions
DATEADD Function 8-44
Considerations for DATEADD 8-45
Return type 8-46
Examples of DATEADD 8-46
DATEDIFF Function 8-46
Considerations for DATEDIFF 8-47
Return type 8-47
Examples of DATEDIFF 8-47
DATEFORMAT Function 8-48
Examples of DATEFORMAT 8-48
DATE_SUB Function 8-48
Considerations for DATE_SUB 8-49
Return type 8-49
Examples of DATE_SUB 8-49
DAY Function 8-50
Examples of DAY 8-50
DAYNAME Function 8-51
Examples of DAYNAME 8-51
DAYOFMONTH Function 8-52
Examples of DAYOFMONTH 8-52
DAYOFWEEK Function 8-53
Examples of DAYOFWEEK 8-53
DAYOFYEAR Function 8-54
Examples of DAYOFYEAR 8-54
DECODE Function 8-55
Considerations 8-55
Examples of DECODE
8-57
DEGREES Function 8-57
Examples of DEGREES 8-57
DIFF1 Function
8-59
Considerations for DIFF1
8-59
Equivalent Result 8-59
Datetime Arguments
8-59
Examples of DIFF1
8-60
DIFF2 Function
8-62
Considerations for DIFF2
8-62
Equivalent Result 8-62
Datetime Arguments
8-62
Examples of DIFF2 8-63