SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Reference Manual—523725-004
xx
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
CODE_VALUE Function 9-29
Considerations for CODE_VALUE Function 9-29
CONCAT Function 9-30
Concatenation Operator (||) 9-30
Considerations for CONCAT 9-30
Examples of CONCAT 9-31
CONVERTTIMESTAMP Function 9-32
Considerations for CONVERTTIMESTAMP 9-32
Examples of CONVERTTIMESTAMP 9-32
COS Function 9-33
Examples of COS 9-33
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
Examples of CURRENT_DATE 9-38
CURRENT_TIME Function 9-39
Examples of CURRENT_TIME 9-39
CURRENT_TIMESTAMP Function 9-40
Examples of CURRENT_TIMESTAMP 9-40
CURRENT_USER Function 9-41
Examples of CURRENT_USER 9-41
DATEFORMAT Function 9-42
Examples of DATEFORMAT 9-42
DAY Function 9-43
Examples of DAY 9-43
DAYNAME Function 9-44
Examples of DAYNAME 9-44
DAYOFMONTH Function 9-45
Examples of DAYOFMONTH 9-45
DAYOFWEEK Function 9-46
Examples of DAYOFWEEK 9-46
DAYOFYEAR Function 9-47
Examples of DAYOFYEAR 9-47