Looks this inconsistency is the result of question merges
Q&A for scientists using computers to solve scientific problems
--SELECT MAX(CreationDate) FROM Votes; /* SELECT DATEFROMPARTS( DATEPART(yyyy, CreationDate), DATEPART(m, CreationDate), 1) FROM Votes WHERE Id=(SELECT MAX(Id) FROM Votes); */ /* DECLARE @a INT; SELECT @a=5; SELECT @a; */ WITH Raw AS ( SELECT Votes.Id AS VoteId, PostsWithDeleted.Id AS PostId, PostsWithDeleted.Id AS [Post Link], DATEFROMPARTS( DATEPART(yyyy, PostsWithDeleted.CreationDate), DATEPART(mm, PostsWithDeleted.CreationDate), DATEPART(day, PostsWithDeleted.CreationDate) ) AS PostDay, Votes.CreationDate AS VoteDay FROM PostsWithDeleted, Votes WHERE PostsWithDeleted.Id = Votes.PostId ) SELECT * FROM Raw WHERE VoteDay < PostDay;