0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

SELECT getDate() as [Date Now], dateadd(DAY, -30, getdate()) as [Date Then]

/*
SELECT top 10
    Id AS [User Link], 
    LastAccessDate,
    dateadd(DAY, -30, getdate()) as [End]
FROM
    Users
WHERE
    LastAccessDate < DateAdd(dd, -30, GetDate()) 
ORDER BY
    LastAccessDate Desc
    */

fork query

edited apr 5 12

created apr 5 12 anonymous