MX 2.x)

ODBC/MX Conformance

HP NonStop ODBC/MX Driver for Windows—527888-004

5-9

SQL Scalar Functions

REPEAT

REPLACE

RIGHT

RTRIM

TRIM...TRAILING

SOUNDEX

Not supported

SPACE

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 5-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 5-12. String Functions (page 2 of 2)

ODBC Function SQL/MX Equivalent Function