GeeCON Prague 2014*
The moose likes JDBC 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
Bookmark "Oracle java date problems" Watch "Oracle java date problems" New topic
Author

Oracle java date problems

Ash More'
Ranch Hand

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





AND THIS IS MY ORACLE PROCEDURE..



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
Bartender

Joined: Dec 20, 2006
Posts: 2501
    
    8

� 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
youtube channel
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