Select CreationDate, LastActivityDate, DateDiff(second, ...

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 

  CreationDate, 
  LastActivityDate, 
  DateDiff(second, CreationDate, LastActivityDate) AS TimeDuration

From Posts
Where Year (CreationDate) in (2017)
AND AcceptedAnswerId is not NULL

Enter Parameters

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