MX Release 3.1 (H06.23+, J06.12+)

ODBC/MX Conformance

HP NonStop Open System Services ODBC/MX Client Driver for SQL/MX Release 3.1—663857-001

3-9

SQL Scalar Functions

SUBSTRING

UCASE

UPPER | UPSHIFT

Note. ODBC string functions in queries can return unexpected results for fixed-length

(CHAR) column names, because SQL/MX pads a fixed-length string with blanks up to the

length of the definition. Therefore, the results from some ODBC string functions can include

trailing blanks at the end of the string. Use the RTRIM function in queries to cause SQL/MX

to trim the extra blanks from the column names.

Table 3-13. Time and Date Functions

ODBC Function SQL/MX Equivalent Function

CURDATE, CURRENT_DATE CURRENT_DATE

CURTIME, CURRENT_TIME CURRENT_TIME

DAY DAY

EXTRACT EXTRACT

DAYNAME Not supported

DAYOFMONTH Not supported

DAYOFWEEK DAYOFWEEK

DAYOFYEAR DAYOFYEAR

HOUR HOUR

MINUTE MINUTE

MONTH MONTH

MONTHNAME MONTHNAME

NOW

Supported, but no equivalent SQL/MX function.

QUARTER QUARTER

SECOND SECOND

TIMESTAMPADD Not supported

TIMESTAMPDIFF Not supported

WEEK WEEK

Table 3-14. System Functions

ODBC Function SQL/MX Equivalent Function

DATABASE Not supported in this release.

IFNULL Not supported in this release.

USER USER

Table 3-12. String Functions (page2of2)

ODBC Function SQL/MX Equivalent Function