SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Contents
HP NonStop SQL/MX Reference Manual—544517-008
xx
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
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
COUNT Function 9-35
Considerations for COUNT 9-35
Examples of COUNT 9-36
CURRENT Function 9-37
Examples of CURRENT 9-37
CURRENT_DATE Function 9-38