Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am receiving 'ErrorMsg: [Oracle] [OCDB] Invalid datetime format' in a QV extract job resulting in no rows being pulled. I know data exists in the associated table as I can view it using another tool. There are multiple date fields in this table - some are populated for some records (but not all) and some are never populated. What do I need to do to resolve this issue? It's never happened before on an extract. I even get this error when I limit the extract to a single non-date field.
No longer an issue.
Could you post your SQL here?
Please post full SQL query.
MariLynne,
If you want to delete this discussion (because it became irrelevant), there is an option to do so on the right under "Actions".
If you want to close the discussion but not let it disappear, mark it as answered. The best thing you can do is add a reply yourself with some sort of explanation, and mark that reply as the correct answer. In that way, you recover the points.
Best,
Peter
No longer an issue.