with sss as (Select Q.CreationDate As QuestionDate, A.Cre...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics

Q&A for professional robotic engineers, hobbyists, researchers and students

with sss as (Select
Q.CreationDate As QuestionDate, A.CreationDate as AnswerDate,
YEAR(Q.CreationDate) as Y,
DATEDIFF(second, Q.CreationDate, A.CreationDate) as TimeDiff
From Posts A
join Posts Q on A.id = Q.AcceptedAnswerid
where Q.AcceptedAnswerId<> '' AND YEAR(Q.CreationDate)=2017)


select max(TimeDiff) from sss

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results