aspose 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


Win a copy of Java 8 in Action this week in the Java 8 forum!
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: 450

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: 450

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: 450

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...
 
Similar Threads
Date Difference
Performence issue:Write query directly in session bean or call storted procedure
J2ee app gets stuck at a stored procedure call
SQLException Cursor Closed
Stored procedure which returns array