PHP数据库中的日期作为时间戳 - 添加X小时

Question

I have Googled and I give up, here goes...

I have always had issues dealing with times/timestamps etc, I am trying to pull a date from my database in SQL TIMESTAMP format, this is what I have so far...

 $db = $row_rsSearch['created_date'];
 $newdate =  date("d/m/Y H:i:s", strtotime('+3 hours', $db));

What is wrong with it? I am getting a return of "31/12/1969 20:33:34" when the database is providing... 2014-04-25 02:19:53

Thanks in advance.

Answer 1

Use DateTime::createFromFormat and DateTime::add

$date = DateTime::createFromFormat('Y-m-d H:i:s', '2014-04-25 02:19:53');
$date->add(new DateInterval('PT3H'));

echo $date->format("d/m/Y H:i:s");