I was looking at:
MySQL Select rows where timestamp column between now and 10 minutes ago
I have a col named creation_date
holding a datetime stamp: 2013-09-10 11:06:42
I would like to pull all records that are OLDER than 15 minutes using:
WHERE creation_date >= DATE_SUB(NOW(),INTERVAL 15 MINUTE)
However the query always returns 0 results, even with items older then 15 minutes present in the database.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…