Who won?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Which answer was posted first? Accurate to the millisecond.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 100
 ID as [Answer ID]
 ,ParentId AS [Post Link] -- We want answers but let's link to the question
,CreationDate
,CONVERT(VARCHAR(12),CreationDate,114) AS [TimeWithMilliseconds] -- 114 is hh:mi:ss:mmm (24h): https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql
FROM POSTS
WHERE
   ParentId = ##QuestionId##
   AND PostTypeId=2 -- Answers
ORDER BY CreationDate asc

Enter Parameters

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