Posted by Greg Donald on 04/09/05 21:18

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/

[Back to original message]