JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Table 10 String Functions (continued)
SQL/MX Equivalent FunctionJDBC Function
TRIM...TRAILINGRTRIM
SPACESPACE
SUBSTRINGSUBSTRING
UPPER | UPSHIFTUCASE
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.
Table 11 Time and Date Functions
SQL/MX Equivalent FunctionJDBC Function
CONVERTTMESTAMPCONVERTTIMESTAMP
CURRENTCURRENT
CURRENT_TIMESTAMPCURRENT_TIMESTAMP
CURRENT_DATECURDATE , CURRENT_DATE
CURRENT_TIMECURTIME , CURRENT_TIME
DATEFORMATDATEFORMAT
DAYDAY
DAYNAMEDAYNAME
DAYOFMONTHDAYOFMONTH
DAYOFWEEKDAYOFWEEK
DAYOFYEARDAYOFYEAR
EXTRACTEXTRACT
HOURHOUR
JULIANTIMESTAMPJULIANTIMESTAMP
MINUTEMINUTE
MONTHMONTH
MONTHNAMEMONTHNAME
QUARTERQUARTER
SECONDSECOND
WEEKWEEK
YEARYEAR
70 JDBC/MX Compliance