To format the DATETIME field taken from the database, you have to turn it into a timestamp.

The DATETIME that comes from your query is actually a string. So, to format it, just use strtotime PHP function:

[code=”php”]
$sql = “SELECT date FROM table WHERE id = ” . $id;
$row = db->select_single($sql); // just an example
$date = $row[‘date’];
echo date(“d.m.Y H:i:s”, strtotime($date));
[/code]

Many times people have problems with formating dates with PHP, but when you get the grip, it really is easy.

Tags: