I am trying to pull some dates out of an Oracle DB but as soon as I try to execute the query I get an error that the "Data type is not supported". I know that the problem is that the date format in the DB is not a valid Date/Time format for VB but I have no idea how to force VB to load it as a String into the record set. The format of the date/time in Oracle is:
7/14/2010 3:01:48.483624 AM
Note the sub-second times. This is what is causing the problem. Unfortunately this is the exact part of the data I need. So the question is how can I pull these dates into VB6?