Re: comparing timestamps
| From: | Marek Kilimajer | Date: | Sun, 20 Jun 2004 23:12:38 +0000 |
| Subject: | Re: comparing timestamps | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-188709@lists.php.net to get a copy of this message | ||
Chris Mach wrote --- napísal::
I want to compare a timestamp in my database with the current time. I want to be able to tell if the timestamp is within 5 mins of the current time. How would I do this? Please?timestamp_column BETWEEN UNIX_TIMESTAMP(NOW() - INTERVAL 5 MINUTE) AND UNIX_TIMESTAMP(NOW() + INTERVAL 5 MINUTE)