Select (TimeDuration / 3600) / 365 AS Years, TimeDuration...

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 / 3600) / 365 AS Years,
 TimeDuration / 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