wood burning stoves
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: 2549

� 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: http://aspose.com/file-tools
subject: Oracle java date problems
It's not a secret anymore!