adding 30 minutes to datetime php/mysql

Question

I have a datetime field (endTime) in mysql. I use gmdate() to populate this endTime field.

The value stored is something like 2009-09-17 04:10:48. I want to add 30 minutes to this endtime and compare it with current time. ie) the user is allowed to do a certain task only 30 minutes within his endTime. After 30 minutes of his endTime, i should not allow him to do a task.

how can i do that in php?

i'm using gmdate to make sure there are no zone differences.

Thanks in advance

Answer 1

If you are using MySQL you can do it like this:

SELECT '2008-12-31 23:59:59' + INTERVAL 30 MINUTE; 

For a pure PHP solution use strtotime

strtotime('+ 30 minute',$yourdate); 

Answer 2

Try this one

DATE_ADD(datefield, INTERVAL 30 MINUTE)