I am trying to find those posts that were edited after a Leave Closed result of a Reopen Votes review queue. For that, I had written the following query in the Stack Exchange Data explorer:
SELECT P.Id P_Id, P.LastEditDate P_LastEditDate, RT.Id RT_Id, RTT.Name RTT_Name, RT.CreationDate RT_CreationDate, RTS.Name RTS_Name, RTR.Id RTR_Id, RTRT.Name RTTR_Name, RTR.CreationDate RTR_CreationDate FROM ReviewTasks RT INNER JOIN ReviewTaskTypes RTT ON RT.ReviewTaskTypeId = RTT.Id INNER JOIN ReviewTaskStates RTS ON RT.ReviewTaskStateId = RTS.Id INNER JOIN ReviewTaskResults RTR ON RT.CompletedByReviewTaskId = RTR.Id INNER JOIN ReviewTaskResultTypes RTRT ON RTR.ReviewTaskResultTypeId = RTRT.Id INNER JOIN Posts P ON RT.PostId = P.Id WHERE (RT.ReviewTaskTypeId = 6 AND RTR.ReviewTaskResultTypeId = 13 AND P.LastEditDate > RTR.CreationDate) ORDER BY P.LastEditDate DESC;
The query works fine, but I have a problem with the posts edited the same day (but before) than the Review Task Result, because it has time 00:00:00.
For a lot of the posts returned, I can see in their timeline that they were edited the same day but before of the Reopen Votes review result. In fact, the post is added to the Reopen Votes review queue from an edit, and is the most common case that the review is resolved the same day.
I can see, in the timeline, the time of the result, so I think it can be stored in some field of the Data Explorer database.
If possible, how can I select the time of the Review Task Result in the Data Explorer database?