SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xxiii
9. SQL/MX Functions and Expressions
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
DATE_ADD Function 9-44
Return Type 9-44
Examples of DATE_ADD 9-44
DATEADD Function 9-44
Considerations for DATEADD 9-45
Return Type 9-46
Examples of DATEADD 9-46
DATEDIFF Function 9-46
Considerations for DATEDIFF 9-47
Return Type
9-47
Examples of DATEDIFF 9-47
DATEFORMAT Function 9-48
Examples of DATEFORMAT
9-48
DATE_SUB Function
9-48
Considerations for DATE_SUB 9-49
Return Type
9-49
Examples of DATE_SUB
9-49
DAY Function
9-50
Examples of DAY
9-50
DAYNAME Function 9-51
Examples of DAYNAME
9-51
DAYOFMONTH Function 9-52