I am hitting SQL Server and Oracle with ODBC APIs and so far haven't found the way to use native functions to retrieve anything other than SQL_C_CHAR (rc = SQLGetData(hstmt, intCol, SQL_C_CHAR, ...)) For example, I don't want to get the DATETIME data type into a character string and then do a Mid(...) on it to get an actual date, - but in stead I want to get the actual date type from the server. Anyone had any luck getting any info on it?

Thanks in advance,

Robert.