MYSQL query / dates older than 1 week ago (all datetimes in UTC)

Viewed 107916

How do I query a mysql db to return all records with a datetime older than 1 week ago. Note that the datetime table stores everything in UTC, and I should be comparing it in that itself.

Just to be clear - I'm looking for a pure mysql query.

3 Answers
Related