HP Integrity NonStop H-Series - Manual (Page 40)

Table 7 Behavior of unsigned data types
Behavior ODBC version
UNSIGNED SMALLINT is promoted to SIGNED INT and
UNSIGNED INT is promoted to BIGINT. 2.0
All unsigned data types are promoted to the next signed
type. 3.x, when server data source is configured with
SQL_ATTR_MSACCESS_VERSION
flag
Partial DATE or TIME values
To use partial DATE or TIME values as parameters, provide these values through the ODBC/MX
data type returned.
To fetch partial DATE or TIME values, see the mappings in Table 8 (page 40) . When you fetch
partial DATE or TIME value character strings, the values are returned as partial even if the driver
returns a full DATE or TIME or TIMESTAMP data type. Default values are returned as a structure (1
for YEAR, MONTH and DAY, and 0 for HOUR, MINUTE, SECOND and FRACTION).
Table 8 SQL/MP to ODBC/MX Date/Time Mappings
ODBC/MX data type SQL/MP data type
SQL_DATE DATETIME YEAR
SQL_DATE DATETIME YEAR TO MONTH
SQL_DATE DATETIME YEAR TO DAY
SQL_TIMESTAMP DATETIME YEAR TO HOUR
SQL_TIMESTAMP DATETIME YEAR TO MINUTE
SQL_TIMESTAMP DATETIME YEAR TO SECOND
SQL_TIMESTAMP DATETIME YEAR TO FRACTION
SQL_DATE DATETIME MONTH
SQL_DATE DATETIME MONTH TO DAY
SQL_TIMESTAMP DATETIME MONTH TO HOUR
SQL_TIMESTAMP DATETIME MONTH TO MINUTE
SQL_TIMESTAMP DATETIME MONTH TO SECOND
SQL_TIMESTAMP DATETIME MONTH TO FRACTION
SQL_DATE DATETIME DAY
SQL_TIMESTAMP DATETIME DAY TO HOUR
SQL_TIMESTAMP DATETIME DAY TO MINUTE
SQL_TIMESTAMP DATETIME DAY TO SECOND
SQL_TIMESTAMP DATETIME DAY TO FRACTION
SQL_TIME DATETIME HOUR
SQL_TIME DATETIME HOUR TO MINUTE
SQL_TIME DATETIME HOUR TO SECOND
SQL_TIMESTAMP DATETIME HOUR TO FRACTION
SQL_TIME DATETIME MINUTE
SQL_TIME DATETIME MINUTE TO SECOND
40 Compatibility and considerations