Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 8, 1999

Difference Between Two Dates

Question:
What is the difference between two dates, date1 and date2, when date2 is in the next record?

Answer:
Use this code:

select datediff(laterone.date1, earlierone.date1) 
from table earlierone, table laterone
where earlier.id > later.id
The idea here is to use the same table twice, with an alias so that you remember the perspective of the table as to earlier or later, then do the subtraction between them.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date