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 Oracle java date problems 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 "Oracle java date problems" Watch "Oracle java date problems" New topic

Oracle java date problems

Ash More'
Ranch Hand

Joined: Apr 20, 2008
Posts: 47
From JAVA the call is made to procedure as follows..


I get exception when I compare the two dates. One comes from JAVA and the other is the ORACLE Database. So I want some function which will convert one of the dates in the other date format.
[ July 23, 2008: Message edited by: Ash More' ]
Jan Cumps

Joined: Dec 20, 2006
Posts: 2565

� I get exception here 2008-08-12 < 12-aug-08 because both dates are different format

Probably not because they are a different format. They are both Oracle DATE columns. 2008-08-12 and 12-aug-08 are merely textual represenatations of these dates.

Can you try if this works:

OCUP UML fundamental and ITIL foundation
Ash More'
Ranch Hand

Joined: Apr 20, 2008
Posts: 47
ok thanks,
the problem seems to be with my table structure.
thanks again
I agree. Here's the link:
subject: Oracle java date problems
jQuery in Action, 3rd edition