troubleshooting Question

date/time in different columns in table - how to find elapsed hours?

Avatar of wvrja
wvrja asked on
12 Comments2 Solutions386 ViewsLast Modified:
   i have a table with the following columns and data:
   start_date                          start_time
=================   =================  
04/10/07 00:00:00          01/01/01 17:32:05  

finish_date                          finish_time
=================   =================
05/31/07 00:00:00           01/01/01 10:50:02
i can get elapsed days with no problem.
is there anyway to calculate elapsed hours from these fields?
Database Consultant
Join our community to see this answer!
Unlock 2 Answers and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros