SQL/MX 2.x Reference Manual (H06.04+)

Contents
HP NonStop SQL/MX Reference Manual—540440-003
xx
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
Considerations for CONCAT 9-28
Examples of CONCAT 9-29
CONVERTTIMESTAMP Function 9-30
Considerations for CONVERTTIMESTAMP 9-30
Examples of CONVERTTIMESTAMP 9-30
COS Function 9-31
Examples of COS 9-31
COSH Function 9-31
Examples of COSH 9-31
COUNT Function 9-32
Considerations for COUNT 9-32
Examples of COUNT 9-33
CURRENT Function 9-34
Examples of CURRENT 9-34
CURRENT_DATE Function 9-35
Examples of CURRENT_DATE 9-35
CURRENT_TIME Function 9-36
Examples of CURRENT_TIME 9-36
CURRENT_TIMESTAMP Function 9-37
Examples of CURRENT_TIMESTAMP 9-37
CURRENT_USER Function 9-37
Examples of CURRENT_USER 9-37
DATEFORMAT Function 9-38
Examples of DATEFORMAT 9-38
DAY Function 9-39
Examples of DAY 9-39
DAYNAME Function 9-40
Examples of DAYNAME 9-40
DAYOFMONTH Function 9-41
Examples of DAYOFMONTH 9-41
DAYOFWEEK Function 9-42
Examples of DAYOFWEEK 9-42
DAYOFYEAR Function 9-43
Examples of DAYOFYEAR 9-43
DEGREES Function 9-44
Examples of DEGREES 9-44
DIFF1 Function 9-45
Considerations for DIFF1 9-45