Subtracting a week from UNIX_TIMESTAMP

Question

I have a query:

SELECT * FROM msc_calendar WHERE calendar_userId = 1 AND end < UNIX_TIMESTAMP() 

Is there a way to subtract a week from the timestamp, i.e. to see if end was more than a week ago?

Answer 1

@EugenRieck's solution will break on edge cases like weeks where there's a daylight savings switch. It's better to use the built-in function for this, DATE_SUB:

SELECT * FROM msc_calendar WHERE calendar_userId = 1 AND 'end' < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 WEEK))

Answer 2

SELECT * FROM msc_calendar WHERE calendar_userId = 1 AND 'end' < UNIX_TIMESTAMP()-7*24*60*60