Php add time to time

Question

I get a date from the database in this format

hh:mm:ss

And I want to add this to the current time and put back to an other table with the following format:

yyyy:mm:dd hh:mm:ss

Answer 1

$a = strtotime($timetoadd);
$b = date('U') + $a;
$c = date('Y-m-d H:i:s',$b);

Edit: Try this instead:

$arr = explode(':',$timetoadd);
$b = mktime(date('h')+$arr[0],date('i')+$arr[1],date('s')+$arr[2],date('m'),date('d'),date('y'));
$c = date('Y-m-d H:i:s',$b);

Answer 2

Assuming you get the time from the database in a variable $dbTime I'd do something like this:

$timeArray = explode (":", $dbTime );
$newTime = time() + ($timeArray[0]*60*60) + ($timeArray[1]*60) + $timeArray[2];
$finalTime = date('Y-m-d H:i:s',$newTime);

May not be the cleanest way but it is an option :)

Answer 3

From your question, I understand that you want your time value from database to be added in the current date time value. Here is the code to do so:-

// hh:mm:ss value you get from your database
$yourDateTime = "SOME DATA";

// current date time
$currentDateTime = date("Y:m:d h:i:s", time());

// separating date and time
$currentDateTimeArray = explode('', $currentDateTime);

// adding your time value to current time value
$currentDateTimeArray[1] = $yourDateTime;

$newDateTime = implode('', $currentDateTimeArray);

Hope this helps. Thanks.