MDAC 2.5 SDK - ODBC Desktop Database Drivers
Type conversion failures result in the affected column being set to NULL.
Neither the DATE nor TIMESTAMP data type can be converted to another data type (or itself) by the CONVERT function.
