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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxxv
8. SQL/MX Functions and Expressions
CODE_VALUE Function 8-30
Considerations for CODE_VALUE Function 8-30
COMPILERCONTROLS Function 8-31
Considerations for COMPILERCONTROLS 8-31
Using SELECT and COMPILERCONTROLS 8-31
Examples of COMPILERCONTROLS 8-32
CONCAT Function 8-34
Concatenation Operator (||) 8-34
Considerations for CONCAT 8-34
Operands 8-34
SQL Parameters 8-34
Examples of CONCAT 8-35
CONVERTTIMESTAMP Function 8-36
Considerations for CONVERTTIMESTAMP 8-36
Relationship to the JULIANTIMESTAMP Function 8-36
Use of CONVERTTIMESTAMP 8-36
Examples of CONVERTTIMESTAMP 8-36
COS Function 8-37
Examples of COS 8-37
COSH Function 8-37
Examples of COSH 8-37
COUNT Function 8-38
Considerations for COUNT 8-38
Operands of the Expression 8-38
Nulls 8-39
Examples of COUNT 8-39
CURRENT Function
8-40
Examples of CURRENT 8-40
CURRENT_DATE Function 8-41
Examples of CURRENT_DATE
8-41
CURRENT_TIME Function
8-42
Examples of CURRENT_TIME 8-42
CURRENT_TIMESTAMP Function
8-43
Examples of CURRENT_TIMESTAMP
8-43
CURRENT_USER Function
8-43
Examples of CURRENT_USER
8-43
DATE_ADD Function 8-44
Return type
8-44
Examples of DATE_ADD 8-44