This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
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


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Default Date format issue in ojdbc6" Watch "Default Date format issue in ojdbc6" New topic
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: 2541
    
  10

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 and ITIL foundation
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Default Date format issue in ojdbc6
 
It's not a secret anymore!