MX 2.x)

LEFT SUBSTRING

LENGTH LENGTH

LOCATE

(JDBC LOCATE start parameter is not supported)

LOWER LOWER

LPAD LPAD

LTRIM LTRIM

OCTET_LENGTH OCTET_LENGTH

POSITION POSITION

REPEAT REPEAT

REPLACE REPLACE

RIGHT RIGHT

RTRIM TRIM...TRAILING

SPACE SPACE

SUBSTRING SUBSTRING

UCASE UPPER | UPSHIFT

Note: JDBC 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, so the results from some JDBC string

functions can include trailing blanks at the end of the string. Use the RTRIM

function in queries to cause SQL/MX to trim extra blanks from the column

names.

Time and Date Functions

JDBC Function SQL/MX Equivalent Function

CONVERTTIMESTAMP CONVERTTMESTAMP

CURRENT CURRENT

CURRENT_TIMESTAMP CURRENT_TIMESTAMP

CURDATE

, CURRENT_DATE

CURRENT_DATE

CURTIME

, CURRENT_TIME

CURRENT_TIME

DATEFORMAT DATEFORMAT

DAY DAY

DAYNAME DAYNAME

DAYOFMONTH DAYOFMONTH

DAYOFWEEK DAYOFWEEK

DAYOFYEAR DAYOFYEAR

EXTRACT EXTRACT