Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-10-25 : 08:54:32
|
Pete writes "Hopefully someone can help me, I am trying to find the time difference between two datetimes in a dataset where the dates are on sequential rows and in different columns.ietblJob_Historyjob job_start_dt job_end_dtaaa01 01/01/2004 20:00 01/01/2004 20:30aaa02 01/01/2004 20:34 01/01/2004 21:45 I am looking to find the difference between job aaa01 endtime and job aaa02 starttime, so the result should be 4 mins.Any help would be greatfully recieved.ThanksPete" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
Difference between datetimes on seperate rows 
