Q&A for Ubuntu users and developers
SELECT * FROM PostsWithDeleted WHERE PostsWithDeleted.CreationDate >= DATEADD(month, -6, GETDATE())