I am having my current application running on weblogic 8.3 (
java 1.4) and
jdbc driver ojdbc14
The default date format used in oracle database is DD-MON-YYYY
When i get the date using rs.getString() , I get the date in default format DD-MON-YYYY
However while upgrading to weblogic 10.3 which uses ojdbc6 the default date format for a date column is datetime
Due to this the existing code which uses rs.getString returns date in different format eg. DD/MM/YYYY HH.MM.SS
Even in case of date column comparision in SQL query ,it gives invalid month error
One solution is to use TO_CHAR() oracle function an give the date format DD-MON-YYYY
Is there any workaround to handle this ,without any code or query change ,so that date is returned in default format DD-MON-YYYY