MX 2.x)

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 SQL/MX

data types:

JDBC Data Type Supported by JDBC/MX SQL/MX Data Type

Types.Array

Types.BIGINT

Yes

LARGEINT

Types.BINARY

Types.BIT