CODEWITHSUNDEEP
phpmysqldatetimestrtotime
someisaac
someisaac

Reputation: 1047

adding 30 minutes to datetime php/mysql

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, they should not be allowed to do a task.

How can this be done in php?

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

Upvotes: 63

Views: 131541

Answers (6)

Balaji
Balaji

Reputation: 45

Get date from MySQL table by adding 30 mins

SELECT loginDate, date_add(loginDate,interval 30 minute) as newLoginDate 
FROM `tableName`;

This will result like below

Login Date - 2020-07-22 14:00:00
New Login Date - 2020-07-22 14:30:00

Upvotes: 1

RageZ
RageZ

Reputation: 27313

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);

Upvotes: 134

Basant Rules
Basant Rules

Reputation: 807

Use DATE_ADD function 

DATE_ADD(datecolumn, INTERVAL 30 MINUTE);

Upvotes: 5

staticsan
staticsan

Reputation: 30555

Dominc has the right idea, but put the calculation on the other side of the expression.

SELECT * FROM my_table WHERE endTime < DATE_SUB(CONVERT_TZ(NOW(), @@global.time_zone, 'GMT'), INTERVAL 30 MINUTE)

This has the advantage that you're doing the 30 minute calculation once instead of on every row. That also means MySQL can use the index on that column. Both of thse give you a speedup.

Upvotes: 5

Dominic Rodger
Dominic Rodger

Reputation: 99751

MySQL has a function called ADDTIME for adding two times together - so you can do the whole thing in MySQL (provided you're using >= MySQL 4.1.3).

Something like (untested):

SELECT * FROM my_table WHERE ADDTIME(endTime + '0:30:00') < CONVERT_TZ(NOW(), @@global.time_zone, 'GMT')

Upvotes: 7

Cem Kalyoncu
Cem Kalyoncu

Reputation: 14593

Try this one

DATE_ADD(datefield, INTERVAL 30 MINUTE)

Upvotes: 53

Related Questions