I have an SQL Query that I'm running from Microsoft Excel to extract data from an Oracle database. I have successfully run this query on 2 computers, however, for some reason, when I run this query on my lap top, I get an ORA-01858: a non-numeric character was found where a numberic is expected error. I have isolated the problem, and found that this line is causing the issue: AND c.START_TIME >= '1-JUN-2005'
AND c.START_TIME < '7-MAY-2006'
If I remove these lines, the query will run on my lap top.
I suspect there is a date format setting that is mis-aligned on this computer, but I can't for the life of me find that setting. My system settings (Windows XP) for long and short date formats are the same on all computers, as are the date settings in MS Excel. I am running Version 9.00.01.08 of the Oracle ODBC driver on all machines as well.
Does anyone have any idea what setting might be messed up on this computer?
Thanks for your help.