Select TimeDuration / 86400 AS Days, (TimeDuration % 8640...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

Select
 TimeDuration / 86400 AS Days,
 (TimeDuration % 86400) / 3600 AS Hours,
 (TimeDuration % 3600) / 60 AS Minutes,
 TimeDuration % 60 AS Seconds

From
 (Select CreationDate, LastActivityDate, 
  DateDiff(second, CreationDate, LastActivityDate) AS TimeDuration From Posts 
  Where Year (CreationDate) in (2017)
  AND AcceptedAnswerId is not NULL) X

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results