old posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gets all posts you have edited and >Gets the difference in months, between when they were created and when they were last active. >Gets the difference in months, between when they were created and when they were **last edited**. This could help you figure how close you are to Excavator and Archeologist

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT top 500
 Id as [Post Link]
 ,body
FROM 
 Posts
WHERE
 DATEDIFF(month,LastActivityDate,GETDATE()) > 6

/* As always I'm doing this as a learning exercise and some of my findings 
were

The column alias cannot be referenced in the select portion of the clause:
http://stackoverflow.com/questions/6591183/t-sql-column-alias-on-computed-column-invalid-column-name

*/

Enter Parameters

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