MX 3.x)

ODBC/MX Conformance

HP NonStop Open System Services ODBC/MX Client Driver—640328-001

3-12

Partial Date/Time Values

•

To use partial date/time values as parameters, provide values through the

ODBC/MX data type returned.

•

To fetch partial date/time values follow table SQL/MP to ODBC/MX Date/Time

Mappings on page 3-12. Partial date/time values fetched as character strings are

returned as partial even when the driver returns a full date/time/timestamp data

type. Default values are returned as a structure (1 for year/month/day, and 0 for

hour/minute/second/fraction).

SQL/MP Data Types and ODBC/MX Equivalents

Table 3-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