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

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xxii
9. SQL/MX Functions and Expressions
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
COALESCE Function 9-27
Considerations 9-27
Examples of COALESCE 9-28
CODE_VALUE Function 9-30
Considerations for CODE_VALUE Function 9-30
COMPILERCONTROLS Function 9-31
Considerations for COMPILERCONTROLS 9-31
Examples of COMPILERCONTROLS 9-32
CONCAT Function 9-34
Concatenation Operator (||) 9-34
Considerations for CONCAT 9-34
Examples of CONCAT 9-35
CONVERTTIMESTAMP Function 9-36
Considerations for CONVERTTIMESTAMP 9-36
Examples of CONVERTTIMESTAMP 9-36
COS Function 9-37
Examples of COS 9-37
COSH Function 9-37
Examples of COSH 9-37
COUNT Function 9-38
Considerations for COUNT 9-38
Examples of COUNT
9-39
CURRENT Function 9-40
Examples of CURRENT 9-40
CURRENT_DATE Function
9-41
Examples of CURRENT_DATE
9-41
CURRENT_TIME Function 9-42
Examples of CURRENT_TIME
9-42
CURRENT_TIMESTAMP Function
9-43
Examples of CURRENT_TIMESTAMP
9-43
CURRENT_USER Function
9-43
Examples of CURRENT_USER 9-43
DATEFORMAT Function
9-44
Examples of DATEFORMAT 9-44