The following table shows the ODBC SQL data types to which year-month interval C data may be converted. For an explanation of the columns and terms in the table, see Converting Data from C to SQL Data ...

[a] All C interval data types can be converted to a character data type. [b] If the type field in the interval structure is such that the interval is a single field (SQL_YEAR or SQL_MONTH), the ...