16

This story-identification question was asked on June 16, 2013; I answered it on July 1, 2013; and my answer was accepted today, April 23, 2021, almost 8 years later. Is this a record?

14

Looks like it. The previous record was about 7 years.

Short story about two brothers leading an expedition to the prehistoric past, one (Orren? Owen?) is killed and erased from history

Our overall record of over 8 years hasn't been broken, though.

What evidence supposedly supports Tau as related to the Necrontyr?

Here's the top 15 at the time of answering (yours isn't in SEDE yet).

Question Tags AnswerDate AcceptDate DaysBetween
What evidence supposedly supports Tau as related to the Necrontyr? 2012-08-31 2021-01-08 3052
Gaiman's Hamnet 2012-07-20 2020-09-25 2989
Why Was the Burrow Burned Down in Half-Blood Prince? 2012-05-31 2020-05-06 2897
How does Bruce travel from The Pit to Gotham City? 2012-08-18 2020-06-11 2854
How do the mutant levels correlate with the mutant classifications? 2011-11-23 2019-09-10 2848
What happened to Pixie in the mines of Abergylid? 2012-06-16 2020-03-24 2838
Why did Lily's enchantments work for Voldemort? 2013-02-24 2020-05-06 2628
Short story about two brothers leading an expedition to the prehistoric past, one (Orren? Owen?) is killed and erased from history 2011-09-10 2018-10-08 2585
Where does the girl from episode 15 end up in the next episode? 2013-09-19 2020-09-30 2568
How did the Witch King of Angmar get his sword back? 2013-04-28 2020-05-06 2565
Who Inherited Bag End? 2013-07-09 2020-05-06 2493
How did Snape get the fake Sword of Gryffindor into Gringotts? 2013-07-15 2020-05-06 2487
Do all Federation starships have stasis chambers for the entire crew? 2011-12-19 2018-07-31 2416
When was Hogwarts founded? 2012-06-17 2019-01-18 2406
Why does Bifur have an axe in his head? 2012-09-03 2019-04-02 2402
2
  • 4
    Thanks! Two good answers but yours came in first so this is the one I accept. I thought about holding off accepting until 2030 so you could have the new overall record, but I might not live that long and anyway meta doesn't count. – user14111 Apr 23 at 10:48
  • @user14111 FWIW This answer wins on meta with a gap of a little under 5 years. – TheLethalCarrot Apr 26 at 8:03
9

I created the following SEDE query to test this:

SELECT a.Id AS [Post Link],
       a.CreationDate AS [Answer Time],
       v.CreationDate AS [Accept Time],
       CONVERT(varchar, DATEDIFF(s, a.CreationDate, v.CreationDate) / 86400)
     + ':'
     + CONVERT(varchar, DATEADD(ms, (DATEDIFF(s, a.CreationDate, v.CreationDate) % 86400) * 1000, 0), 114)
     AS [Difference]
FROM Posts a
JOIN Votes v ON a.Id = v.PostId
WHERE VoteTypeId = 1
AND DATEDIFF(s, a.CreationDate, v.CreationDate) > 31557600
ORDER BY DATEDIFF(s, a.CreationDate, v.CreationDate) DESC

The top 5 results are as follows:

Answer Answer Time Accept Time Answerer Questioner Difference
What evidence supposedly supports Tau as related to the Necrontyr? 2012-08-31 23:22:28 2021-01-08 00:00:00 Thaddeus Howze AncientSwordRage 3051:00:37:32
Gaiman's Hamnet 2012-07-20 21:56:52 2020-09-25 00:00:00 dlanod Andrés E. Caicedo 2988:02:03:08
Why Was the Burrow Burned Down in Half-Blood Prince? 2012-05-31 07:48:43 2020-05-06 00:00:00 Tango Slytherincess 2896:16:11:17
How does Bruce travel from The Pit to Gotham City? 2012-08-18 18:21:59 2020-06-11 00:00:00 Jack B Nimble Wipqozn 2853:05:38:01
How do the mutant levels correlate with the mutant classifications? 2011-11-23 02:58:50 2019-09-10 00:00:00 Thaddeus Howze Jack B Nimble 2847:21:01:10

Your difference actually comes in at roughly 2997 days 20:12:45 and so when SEDE updates it will come in second overall but the top one for !


A markdown friendly version of the query can be found here if anyone ever wants to add to this.

2
  • 1
    I blame those damn pesky mods from taking away your victory! – TheLethalCarrot Apr 23 at 8:34
  • It's certainly the record for Story-ID – Valorum Apr 23 at 8:45

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .