SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Contents
HP NonStop SQL/MX Reference Manual—640322-001
xxi
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
ATAN Function 9-13
Examples of ATAN 9-13
ATAN2 Function 9-13
Examples of ATAN2 9-13
AVG Function 9-14
Considerations for AVG 9-14
Examples of AVG 9-15
CASE (Conditional) Expression 9-16
Considerations for CASE 9-17
Examples of CASE 9-18
CAST Expression 9-20
Considerations for CAST 9-20
Valid Conversions for CAST 9-20
Examples of CAST 9-21
CEILING Function 9-22
Examples of CEILING 9-22
CHAR Function 9-23
Examples of CHAR 9-23
CHAR_LENGTH Function 9-24
Considerations for CHAR_LENGTH 9-24
SQL/MP Considerations for CHAR_LENGTH 9-24
Examples of CHAR_LENGTH 9-25
CODE_VALUE Function 9-27
Considerations for CODE_VALUE Function 9-27
COMPILERCONTROLS Function 9-28
Considerations for COMPILERCONTROLS 9-28
Examples of COMPILERCONTROLS 9-29
CONCAT Function 9-31
Concatenation Operator (||) 9-31
Considerations for CONCAT 9-31
Examples of CONCAT 9-32
CONVERTTIMESTAMP Function 9-33
Considerations for CONVERTTIMESTAMP 9-33
Examples of CONVERTTIMESTAMP 9-33
COS Function 9-34
Examples of COS 9-34
COSH Function 9-34
Examples of COSH 9-34