mySql timestamp
| From: | Bryan Fritchie | Date: | Sat, 05 Aug 2000 21:04:44 +0000 |
| Subject: | mySql timestamp | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-10271@lists.php.net to get a copy of this message | ||
I am having a rough time with a timestamp issue. I want to pull everything that has been updated in
the last 15 minutes.
Here is my select statement....
SELECT fieldname, DATE_FORMAT(timestamp, '%l:%i:%s %p') as timestamp
FROM tablename
WHERE timestamp > now() - 900 ' 15 minutes * 60 seconds?
ORDER BY timestamp DESC
For some reason, it is returning *everything*.