Posted by Greg Donald on 04/09/05 20:28

On Apr 9, 2005 12:35 PM, Ryan A <ryan@coinpass.com> wrote:
> Hey,
> I thought this would be simple and just a few mins of programming but along
> the way...i have managed to confuse myself ;-D
>
> I have 2 field in my table users_online:
> present_date_time datetime
> expires_in datetime
>
> for present_date_time I am using now() to insert
> but for expires_in I need to have it now()+5 mins
>
> I was screwing around with now()+ X
> but thats getting me some weird results if its the end of the hour or day...

mysql> select NOW(), DATE_ADD( NOW(), INTERVAL 5 MINUTE );
+---------------------+--------------------------------------+
| NOW() | DATE_ADD( NOW(), INTERVAL 5 MINUTE ) |
+---------------------+--------------------------------------+
| 2005-04-09 12:27:36 | 2005-04-09 12:32:36 |
+---------------------+--------------------------------------+
1 row in set (0.00 sec)


--
Greg Donald
Zend Certified Engineer
http://destiney.com/

[Back to original message]