JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

CURTIME

CURRENT_TIME

DATEFORMAT DATEFORMAT

DAY DAY

DAYNAME DAYNAME

DAYOFMONTH DAYOFMONTH

DAYOFWEEK DAYOFWEEK

DAYOFYEAR DAYOFYEAR

EXTRACT EXTRACT

HOUR HOUR

JULIANTIMESTAMP JULIANTIMESTAMP

MINUTE MINUTE

MONTH MONTH

MONTHNAME MONTHNAME

QUARTER QUARTER

SECOND SECOND

WEEK WEEK

YEAR YEAR

System Functions

JDBC Function SQL/MX Equivalent Function

CURRENT_USER CURRENT_USER

SYSTEM_USER SYSTEM_USER

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), the equivalent SQL/MX data type is a string literal with a value of CHARACTER.

JDBC Data Types

The following table shows the JDBC data types that are supported by JDBC/MX and their corresponding