Timediff
Aug 23, 2006Hi
I have store minutes in numeric field in a table (Totmin)
Now i want to convert it into hour & minutes
Ex: Totmin - 114
result : 1 hours 54 minutes
How can i get it through SELECT statement
Thanks
ASM
ADVERTISEMENT
Need Help With Query That Does Both Timediff && Sum
Jul 23, 2005Hello,Am trying to construct a query that'll both compute elapsed time basedon certain criteria and sum this up for a subset of records.Sample Data that I'm working with:RowEv_Time Ev_idEv_Desc-------------------------------------------------------------------12004-12-03 14:28:45400Batch set Run22004-12-03 14:28:45201Batch received Start32004-12-03 14:28:45500Unit Received Run42004-12-03 14:28:45502Operation Received Run52004-12-03 14:28:45210Allocated62004-12-03 14:28:45227Set Start72004-12-03 14:28:45226Received Ready82004-12-03 14:28:47228Received Run92004-12-03 14:28:49230Received Held102004-12-03 14:30:49231Set Restart........282004-12-03 14:40:02230Received Held292004-12-03 14:40:32231Set Restart302004-12-03 14:40:35234Received Done312004-12-03 14:40:35235Set Reset322004-12-03 14:40:35226Received Ready332004-12-03 14:40:35227Set Start342004-12-03 14:40:37228Received Run352004-12-03 14:45:28234Received Done362004-12-03 14:45:28235Set Reset372004-12-03 14:45:28226Received Ready382004-12-03 14:45:28227Set Start392004-12-03 14:45:29228Received Run402004-12-03 15:26:20229Set Hold412004-12-03 15:27:20209Batch set Aborted422004-12-07 15:23:36206Batch set ClosedNeed query that'll compute timediffs between ev_ids (230 & 231) & (229,209) across all records and then sum it up:ie: SUM (timediffs between row pairs (9,10), (28,29) & (40,41) )120 + 30 + 60 = 210 SecondsAny tips would be welcomeThanks-D
View 3 Replies View RelatedFind Duplicate Values And Get Timediff
Dec 10, 2013Is there a way to find duplicate values and get the timediff from the start and end of each duplicate.
datetimeTagname value MachineValueTime Diff Minutes
12/9/13 8:55machine_1 14,423 Machine_1 14,423 5
12/9/13 9:00machine_1 14,423 Machine_1 14,428 9
12/9/13 9:05machine_1 14,428 Machine_1 42,743 4
12/9/13 9:10machine_1 14,428
12/9/13 9:14machine_1 14,428
12/9/13 11:32machine_1 42,743
12/9/13 11:36machine_1 42,743