MySQL Forums
Forum List  »  Newbie

Re: Complex Query - subtract two event times
Posted by: Shantanu Oak
Date: March 23, 2006 07:56AM

SELECT t.dtstamp - t1.dtstamp AS difference_in_days
FROM dura AS t INNER JOIN dura AS t1
WHERE t.EventID=t1.EventID AND t.ActionID>t1.ActionID

Options: ReplyQuote


Subject
Written By
Posted
Re: Complex Query - subtract two event times
March 23, 2006 07:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.