select parentid, creationdate from posts where year(creat...

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

select parentid, creationdate
from posts
where year(creationdate) = 2017
and acceptedanswerid is not null
and month(creationdate) = 1
and day(creationdate) >= 1
and day(creationdate) < 16
and posttypeid = 1;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results