NonStop Server for Java (NSJ) Programmer's Guide (NSJ 2.1+)

CURDATE,

CURRENT_DATE

CURTIME,

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 NOW

QUARTER QUARTER

SECOND SECOND

TIMESTAMPADD

Not supported

TIMESTAMPDIFF

Not supported

WEEK WEEK

System Functions

JDBC Function SQL/MX Equivalent Function

DATABASE

Not supported in this release

IFNULL

Not supported in this release

USER USER

CONVERT Function

JDBC/MX uses the SQL/MX CAST function to support the JDBC CONVERT function. The JDBC CONVERT function

has the following format:

{ fn CONVERT( value_exp, data_type ) }

The SQL/MX CAST has this format:

CAST( { value_exp | NULL } AS data_type )

SQL/MX translates the CONVERT syntax to the CAST syntax, converting the data type argument to its equivalent

SQL/MX value. For example, if the JDBC data type parameter for character data is an integer value (SQL_CHAR or 1),