Quote:
Originally Posted by Mordachai
[You must be logged in to view images. Log in or Register.]
it sounds like it is a timestamp in the vein of "# of seconds since January 1, 1970" or something similar, in which case you could convert getdate() into seconds and then subtract that value and then calculate how long?
|
I'm bored at work, so I looked it up, and you're right.
Add this to the where clause to get accounts active in the last 30 days
Code:
DateDiff(day, DateAdd(second, timelaston, '1/1/1970'), GetDate()) <= 30