DECLARE @last datetime SET @last = (SELECT create_date F...


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Write a well-received answer to a question from a "New contributor"
-- The Q and the A must both have a positive score.

DECLARE @last datetime
SET @last = (SELECT create_date FROM sys.databases WHERE name = 'StackOverflow')
DECLARE @first datetime
SET @first = DATEADD(day, -7, @last)

FROM Posts q
WHERE q.CreationDate > '2022-12-14'

Enter Parameters

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