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

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xxvii
9. SQL/MX Functions and Expressions
Examples of SECOND 9-162
SESSION_USER Function 9-163
Examples of SESSION_USER 9-163
SIGN Function 9-163
Examples of SIGN 9-163
SIN Function 9-164
Examples of SIN 9-164
SINH Function 9-164
Examples of SINH 9-164
SPACE Function 9-165
Examples of SPACE 9-165
SQRT Function 9-165
Examples of SQRT 9-165
STDDEV Function 9-166
Considerations for STDDEV 9-166
Examples of STDDEV 9-167
SUBSTRING Function 9-169
Considerations for SUBSTRING 9-169
Examples of SUBSTRING 9-170
SUM Function 9-171
Considerations for SUM 9-171
Examples of SUM 9-172
TAN Function 9-173
Examples of TAN 9-173
TANH Function 9-173
Examples of TANH 9-173
THIS Function
9-174
Considerations for THIS 9-174
Example of THIS 9-174
TO_CHAR(<NUMERIC>) Function
9-176
Considerations
9-178
Examples of TO_CHAR(<NUMERIC>) 9-180
TO_CHAR(<DATETIME>) Function
9-180
Considerations
9-184
Examples of TO_CHAR(<DATETIME>)
9-185
TRANSLATE Function
9-185
TRIM Function 9-187
Considerations for TRIM
9-187
Examples of TRIM 9-187