Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subtracting Dates

Status
Not open for further replies.
AMS100

AMS100

Programmer
Oct 19, 2001
111
GB
I hope this is the right forum! Im using Oracle Discoverer (ver 9) and have 2 date fields im trying to subtract from weach other to give the time difference. Does anybofy have any idea on how to do this??
Thanks
 
Sort by date Sort by votes
By subtracting two dates you get the result that shows the number of days between the dates. You will need to recalculate this number to get the desired time. For example, to get the number of hours, you need to divide the difference by 24, and so on.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ejeffcott
  • Locked
  • Question
How to Group Dates
Replies
2
Views
44
nagornyi
nagornyi

Part and Inventory Search

Sponsor

Back
Top