All Answers Before 01-Jan-2015

0

Please login or register to vote for this query.

(click on this box to dismiss)

Hinduism

Q&A for followers of the Hindu religion and those interested in learning more about Hinduism

declare @before datetime = 'Jan 1 2015';

SELECT A.Id AS [Post Link], A.CreationDate AS 'Date Answered', A.Score AS Votes, U.DisplayName AS Username
  FROM Posts A JOIN Users U ON A.OwnerUserId = U.Id
    WHERE A.CreationDate < @before
    AND A.PostTypeId = 2 -- Post is answer
    ORDER BY A.CreationDate ASC;

Enter Parameters

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