ORA-01843: not a valid month
OK people...hope this is an easy one for y'all.
This just came up today. The System been running fine and no changes has been made, but all of a sudden, users are complaining they are getting this error from querying a table.
When I try to do a select * from table; from sqlplus, the records are returned but at the end of the output, there's the error! - THE ERROR APPEARS AT THE END OF THE RESULTS.
What's more wierd is that this particular table has NO date columns at all. Although it does have columns of varchar type that appear to hold date values.
Can someone explain this error in this situation?