PHP Add Time to Existing Stored Time

Question

I am trying to add 55 minutes to a set time stored in the database. I am running an MySQL Query to get the time information. This is stored in the PHP Script as $row['login_time'].

If is getting stored in the database in the format like 2013-04-25 22:48:53 EDT.

I am trying to add 55 minutes to this time.

I have the following script but it is showing a value in 1969.

$seconds = 55 * 60;
echo date("Y-m-d H:i:s", $row['login_time'] + $seconds);

Poss. dup. http://stackoverflow.com/questions/8169139/adding-minutes-to-date-time-in-php — user1477388, Apr 26 '13 at 17:51
Use the DateTime class: http://www.php.net/manual/en/datetime.add.php — millimoose, Apr 26 '13 at 17:52
Your code doesn't work for the same reason that `'one' + 'five'` doesn't return `'six'`. — Álvaro González, Apr 26 '13 at 17:53
@ÁlvaroG.Vicario That's not a behaviour that would surprise me in PHP. I thought it would coerce the datetime string to the number 2012 — millimoose, Apr 26 '13 at 18:27

score 2 · Accepted Answer · answered Apr 26 '13 at 17:52

2

You should convert the DATETIME field to the value in seconds, you can use the php function strtotime

$seconds = 55 * 60;
echo date("Y-m-d H:i:s", strtotime($row['login_time']) + $seconds);

answered Apr 26 '13 at 17:52

Miguel G. Flores

802
7
21

score 0 · Answer 2 · answered Apr 26 '13 at 17:53

0

You need to add the seconds after converting the date to a UNIX timestamp.

$seconds = 55 * 60;
$timestamp = strtotime(date("Y-m-d H:i:s", $row['login_time'])) + $seconds;
echo $timestamp;

answered Apr 26 '13 at 17:53

Cory Shaw

1,130
10
16

score 0 · Answer 3 · answered Apr 26 '13 at 18:22

0

No need to get PHP involved:

UPDATE yourtable
SET timefield = timefield + INTERVAL 55 MINUTE

or

...
SET timefield = DATE_ADD(timefield, INTERVAL 55 MINUTE)

answered Apr 26 '13 at 18:22

Marc B

356,200
43
426
500

PHP Add Time to Existing Stored Time

3 Answers3