| Author |
Default Date format issue in ojdbc6
|
sandeepn. nayak
Greenhorn
Joined: Dec 08, 2010
Posts: 1
|
|
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
|
 |
Jan Cumps
Bartender
Joined: Dec 20, 2006
Posts: 2343
|
|
Welcome to JavaRanch, Sandeepn
As a workaround, after creating the connection you can execute this statement:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY'
To prevent issues; whenever dealing with dates, it might be better to not use String, but Date.
|
OCUP UML fundamental
ITIL foundation
|
 |
 |
|
|
subject: Default Date format issue in ojdbc6
|
|
|