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

Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language

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

*/

fork query

edited jul 3 12 anonymous

created mar 4 12 gideon