File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Dates in Oracle functions... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Dates in Oracle functions..." Watch "Dates in Oracle functions..." New topic
Author

Dates in Oracle functions...

Rizvan Asgarov
Ranch Hand

Joined: Jan 07, 2009
Posts: 451

Hi Friends,
I want to get number of days, hours and minutes between dates...

But, my script does not yield results true:

Any help would be greatly appreciated,
Rizvan

"Half of the science is to ask question"
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14687
    
  16

Look at this article, "Subtraction of two TIMESTAMP datatypes"


[My Blog]
All roads lead to JavaRanch
Rizvan Asgarov
Ranch Hand

Joined: Jan 07, 2009
Posts: 451

Thanks Christophe,

Yeah, I solved it by this article...

But, how do I use my select by function together?


Thanks in advance,
Rizvan
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14687
    
  16

Inject the result of the SELECT into a variable, using "INTO difference".
Rizvan Asgarov
Ranch Hand

Joined: Jan 07, 2009
Posts: 451

But, what is the mistake at the following code when using into clause:


Thanks in advance,
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Dates in Oracle functions...