I'm trying to save data using ZF2 Doctrine ORM Module using dynamic paramter as entity class name and initializing its object and saving data using dynamic values from excel sheet header,
$time = \PHPExcel_Style_NumberFormat::toFormattedString($rowData[0][$key], 'hh:mm:ss');
$obj->$setter(\DateInterval::createFromDateString($this->secondsToTime(strtotime($time))));
$this->orm->persist($obj);
$this->orm->flush();
$this->secondsToTime(strtotime($time)) is returning time in format 4 hours 5 minutes 6 seconds
Field type is time, when I print $obj->getter(), it prints:
DateInterval Object
(
[y] => 0
[m] => 0
[d] => 0
[h] => 4
[i] => 5
[s] => 6
[weekday] => 0
[weekday_behavior] => 0
[first_last_day_of] => 0
[invert] => 0
[days] =>
[special_type] => 0
[special_amount] => 0
[have_weekday_relative] => 0
[have_special_relative] => 0
)
But it doesn't save its value as 4:05:06 in database, it saves 00:00:00. I tried answer from here