0

Please login or register to vote for this query.

(click on this box to dismiss)

See below for context https://gaming.meta.stackexchange.com/q/12638/28182

Q&A for professional and enthusiast programmers

SELECT TOP 100
 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 IS NOT NULL
   AND PostTypeId=2 -- Answers
ORDER BY ParentId desc, CreationDate desc

fork query

edited sep 21 17 Robotnik.

created sep 21 17 anonymous