File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Default Date format issue in ojdbc6 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Default Date format issue in ojdbc6" Watch "Default Date format issue in ojdbc6" New topic

Default Date format issue in ojdbc6

sandeepn. nayak

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

Joined: Dec 20, 2006
Posts: 2562

Welcome to JavaRanch, Sandeepn

As a workaround, after creating the connection you can execute this statement:

To prevent issues; whenever dealing with dates, it might be better to not use String, but Date.

OCUP UML fundamental and ITIL foundation
subject: Default Date format issue in ojdbc6
It's not a secret anymore!