Latest date with posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

--According to http://data.stackexchange.com/faq
-- Data is updated monthly.
-- using http://data.stackexchange.com/stackoverflow/query/119278/posts-per-day-desc
-- there are some records for 2Jun and full list for 1Jun
-- this query is returning 2Jun


SELECT top 1
cast( Posts.CreationDate as date) 
FROM 
  Posts
 ORDER BY Posts.CreationDate desc

Enter Parameters

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