Two Laptop Bag
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: 2565

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
I agree. Here's the link:
subject: Default Date format issue in ojdbc6
jQuery in Action, 3rd edition