RE: [PHP-DEV] mySql timestamp
| From: | Theodore | Date: | Sat, 05 Aug 2000 19:26:46 +0000 |
| Subject: | RE: [PHP-DEV] mySql timestamp | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-27850@lists.php.net to get a copy of this message | ||
I'd use a query... something like
SELECT (something,seomthing,timestame) FROM table_name WHERE timestame =
now()-15;
-Theodore
-----Original Message-----
From: Bryan Fritchie [mailto:bryan@razorhack.com]
Sent: Saturday, August 05, 2000 2:12 PM
To: php-dev@lists.php.net
Subject: [PHP-DEV] mySql timestamp
What is the best way to compare a timestamp, and see if it has occurred,
say, within a 15 minutes of the current time? I can't find any sort of
datediff functions like you might have in ASP.
Any help is appreciated. Thanks!