Re: [SQL] calculate time diffs across rows with single timestamp

2007-06-13 Thread Bob Singleton
Rodrigo De León wrote: On Jun 13, 11:17 am, [EMAIL PROTECTED] (Bob Singleton) wrote: Any suggestions on how I can build a result set that would return ASSET 001 AAA 1:00 (1 hour) ASSET 001 BBB 0:10 (10 minutes) ASSET 001 CCC 0:08 (8 minutes) ASSET 001 DDD {difference between times

Re: [SQL] calculate time diffs across rows with single timestamp

2007-06-13 Thread Rodrigo De León
On Jun 13, 11:17 am, [EMAIL PROTECTED] (Bob Singleton) wrote: > Any suggestions on how I can build a result set that would return > > ASSET 001 AAA 1:00 (1 hour) > ASSET 001 BBB 0:10 (10 minutes) > ASSET 001 CCC 0:08 (8 minutes) > ASSET 001 DDD {difference between timestamp and now()} > ASSET 002 A