ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—691126-002
5-13
SQL/MP Data Types and ODBC/MX Equivalents
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.