all posts you have edited with their date and activity information

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

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

SELECT
 Id as post_id
 ,LastActivityDate As last_active
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 sites:
loading Hold tight while we fetch your results