ODBC/MX Driver for Windows Manual (SQL/MX 3.x)

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—640329-001
5-13
SQL/MP Data Types and ODBC/MX Equivalents
SQL/MP Data Types and ODBC/MX Equivalents
Microsoft Escape Clauses
ODBC/MX accepts Microsoft escape clauses and translates them into equivalent
SQL/MX clauses.
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