MX Release 3.2.1 (H06.26+, J06.15+)

Table 15 Time and Date Functions (continued)

SQL/MX Equivalent FunctionODBC Function

SECONDSECOND

Not supportedTIMESTAMPADD

Not supportedTIMESTAMPDIFF

WEEKWEEK

Table 16 System Functions

SQL/MX Equivalent FunctionODBC Function

Not supported in this release.DATABASE

Not supported in this release.IFNULL

USERUSER

CONVERT Function

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

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 ODBC 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.

ODBC Data Types

Table 17 ODBC Data Types

Supported by ODBC/MXSQL/MP Data TypeSQL/MX Data TypeODBC Data Type

YesCHAR(n)CHAR(n)CHAR(n)

YesVARCHAR(n)*VARCHAR(n) *VARCHAR(n)

YesVARCHAR(n)VARCHAR(n)LONGVARCHAR

YesDECIMAL(p,s)DECIMAL(p,s)DECIMAL(p,s)

YesNUMERIC(p,s)NUMERIC(p,s)**NUMERIC(p,s)

YesSMALLINTSMALLINTSMALLINT

YesINTEGERINTEGERINTEGER

YesREALREALREAL

YesFLOAT(p)FLOAT(p)FLOAT(p)

YesDOUBLE PRECISIONDOUBLE PRECISIONDOUBLE PRECISION

NoNot supportedNot supportedBIT

NoNot supportedNot supportedTINYINT

NoNot supportedNot supportedTINYINT UNSIGNED

YesLARGEINTLARGEINTBIGINT

38 ODBC/MX Conformance