Re: Alternate to timediff() (might be slightly 0T)
| From: | Greg Donald | Date: | Sat, 09 Apr 2005 18:18:10 +0000 |
| Subject: | Re: Alternate to timediff() (might be slightly 0T) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-212735@lists.php.net to get a copy of this message | ||
On Apr 9, 2005 1:09 PM, Ryan A <ryan@coinpass.com> wrote:
> So how can I compare 2 timedates which are:
>
> now() and now() + 5 mins
>
> to see if I get a positive or negitive value?
mysql> select NOW() > DATE_ADD( NOW(), INTERVAL 5 MINUTE );
+----------------------------------------------+
| NOW() > DATE_ADD( NOW(), INTERVAL 5 MINUTE ) |
+----------------------------------------------+
| 0 |
+----------------------------------------------+
1 row in set (0.01 sec)
mysql> select NOW() < DATE_ADD( NOW(), INTERVAL 5 MINUTE );
+----------------------------------------------+
| NOW() < DATE_ADD( NOW(), INTERVAL 5 MINUTE ) |
+----------------------------------------------+
| 1 |
+----------------------------------------------+
1 row in set (0.00 sec)
--
Greg Donald
Zend Certified Engineer
http://destiney.com/