Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

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 19 SQL/MP to ODBC/MX Date/Time Mappings
ODBC/MX Data Type ReturnedSQL/MP Data Type
SQL_DATEDATETIME YEAR
SQL_DATEDATETIME YEAR TO MONTH
SQL_DATEDATETIME YEAR TO DAY
SQL_TIMESTAMPDATETIME YEAR TO HOUR
SQL_TIMESTAMPDATETIME YEAR TO MINUTE
SQL_TIMESTAMPDATETIME YEAR TO SECOND
SQL_TIMESTAMPDATETIME YEAR TO FRACTION
SQL_DATEDATETIME MONTH
SQL_DATEDATETIME MONTH TO DAY
SQL_TIMESTAMPDATETIME MONTH TO HOUR
SQL_TIMESTAMPDATETIME MONTH TO MINUTE
SQL_TIMESTAMPDATETIME MONTH TO SECOND
SQL_TIMESTAMPDATETIME MONTH TO FRACTION
SQL_DATEDATETIME DAY
SQL_TIMESTAMPDATETIME DAY TO HOUR
SQL_TIMESTAMPDATETIME DAY TO MINUTE
SQL_TIMESTAMPDATETIME DAY TO SECOND
SQL_TIMESTAMPDATETIME DAY TO FRACTION
SQL_TIMEDATETIME HOUR
SQL_TIMEDATETIME HOUR TO MINUTE
SQL_TIMEDATETIME HOUR TO SECOND
SQL_TIMESTAMPDATETIME HOUR TO FRACTION
SQL_TIMEDATETIME MINUTE
SQL_TIMEDATETIME MINUTE TO SECOND
SQL_TIMESTAMPDATETIME MINUTE TO FRACTION
SQL_TIMEDATETIME SECOND
SQL_TIMESTAMPDATETIME SECOND TO FRACTION
40 ODBC/MX Conformance