Tag: to_date

Message: ORA-01843: not a valid month

This stuff makes me confuse and headache for a few days. Why? It is about date format in select query oracle. I don’t know if this has been an issue. I have select SQL query in ORACLE that contains date format, I use to_date(targetdate, ‘DD-MON-YY’) format. Every thing works well in development server that has database connection string to database development server using oracle, but when I change connection to database production server, some thing happens. No data appear and no error, a mystery. Why?

I need more than a hours to find the solutions. Every thing has been done, debug from visual studio and makes connection directly to production server, no error found and the data appear, copy database production and restore to development server, no error found and the data appear. But if I make connection directly from development …