MX Release 3.1 (H06.23+, J06.12+)

ODBC/MX Conformance

HP NonStop ODBC/MX Driver for Windows for SQL/MX Release 3.1—663858-001

5-13

SQL/MP Data Types and ODBC/MX Equivalents

Table 5-17. SQL/MP to ODBC/MX Date/Time Mappings

SQL/MP Data Type ODBC/MX Data Type Returned

DATETIME YEAR SQL_DATE

DATETIME YEAR TO MONTH SQL_DATE

DATETIME YEAR TO DAY SQL_DATE

DATETIME YEAR TO HOUR SQL_TIMESTAMP

DATETIME YEAR TO MINUTE SQL_TIMESTAMP

DATETIME YEAR TO SECOND SQL_TIMESTAMP

DATETIME YEAR TO FRACTION SQL_TIMESTAMP

DATETIME MONTH SQL_DATE

DATETIME MONTH TO DAY SQL_DATE

DATETIME MONTH TO HOUR SQL_TIMESTAMP

DATETIME MONTH TO MINUTE SQL_TIMESTAMP

DATETIME MONTH TO SECOND SQL_TIMESTAMP

DATETIME MONTH TO FRACTION SQL_TIMESTAMP

DATETIME DAY SQL_DATE

DATETIME DAY TO HOUR SQL_TIMESTAMP

DATETIME DAY TO MINUTE SQL_TIMESTAMP

DATETIME DAY TO SECOND SQL_TIMESTAMP

DATETIME DAY TO FRACTION SQL_TIMESTAMP

DATETIME HOUR SQL_TIME

DATETIME HOUR TO MINUTE SQL_TIME

DATETIME HOUR TO SECOND SQL_TIME

DATETIME HOUR TO FRACTION SQL_TIMESTAMP

DATETIME MINUTE SQL_TIME

DATETIME MINUTE TO SECOND SQL_TIME

DATETIME MINUTE TO FRACTION SQL_TIMESTAMP

DATETIME SECOND SQL_TIME

DATETIME SECOND TO FRACTION SQL_TIMESTAMP

Note. The SQL/MP Datatypes DATETIME YEAR TO SECOND and DATETIME YEAR TO

FRACTION support the SQL Fraction Precision Value of 9. You can set the SQL Fraction

Precision value while configuring the Client Datasource. The default value is 6.