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

Contents
HP NonStop SQL/MX Reference Manual—544517-008
xxi
9. SQL/MX Functions and Expressions (continued)
9. SQL/MX Functions and Expressions (continued)
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-40
Examples of CURRENT_USER 9-40
DATEFORMAT Function 9-41
Examples of DATEFORMAT 9-41
DAY Function 9-42
Examples of DAY 9-42
DAYNAME Function 9-43
Examples of DAYNAME 9-43
DAYOFMONTH Function 9-44
Examples of DAYOFMONTH 9-44
DAYOFWEEK Function 9-45
Examples of DAYOFWEEK 9-45
DAYOFYEAR Function 9-46
Examples of DAYOFYEAR 9-46
DEGREES Function 9-47
Examples of DEGREES 9-47
DIFF1 Function 9-48
Considerations for DIFF1 9-48
Examples of DIFF1 9-49
DIFF2 Function 9-51
Considerations for DIFF2 9-51
Examples of DIFF2 9-52
EXP Function 9-54
Examples of EXP 9-54
EXPLAIN Function 9-55
Considerations for EXPLAIN 9-56
Examples of EXPLAIN 9-59
EXTRACT Function 9-63
Examples of EXTRACT 9-63
FLOOR Function 9-64
Examples of FLOOR 9-64
HASHPARTFUNC Function 9-65
Considerations for HashPartFunc 9-65