SQL时间戳 - > 1970

Question

I want to output the time, when my form saves a input. Here is my code, my DB settings and my output. I hope someone can help me. I am new in PHP and SQL and I am very proud so far. :)

<?php 
$dbLink=mysql_connect('','',''); 
mysql_select_db('',$dbLink); 

$abfrage='SELECT * FROM links ORDER BY Zeit DESC'; 
$ergebnis=mysql_query($abfrage); 
?>

<?php
while($row=mysql_fetch_object($ergebnis))
{
echo "<tr>";
echo "<td>".date("d.m.Y",$row->Zeit)."</td>";
echo "<td><a href='".$row->url."' target='_blank'>".$row->text."</a></td>";
echo "<td>".$row->kategorie."</td>";
echo "</tr>";
}
?>

Answer 1

date() requires a Unix Timestamp as its second parameter. You need to convert that MySQL datetime value into a Unix Timestamp using strtotime()before date() can transform it:

echo "<td>".date("d.m.Y",strtotime($row->Zeit))."</td>";