Using a datetime field from a mysql database e.g. "2012-03-24 17:45:12"
<?php
$result = mysql_query(«SELECT datetime FROM table«);
$row = mysql_fetch_row($result);
date_default_timezone_set(‘Europe/Madrid’);
$date = date_create($row[0]);
echo date_format($date, ‘Y-m-d H:i:s’);
#output: 2012-03-24 17:45:12
echo date_format($date, ‘d/m/Y H:i:s’);
#output: 24/03/2012 17:45:12
echo date_format($date, ‘d/m/y’);
#output: 24/03/12
echo date_format($date, ‘g:i A’);
#output: 5:45 PM
echo date_format($date, ‘G:ia’);
#output: 05:45pm
echo date_format($date, ‘g:ia on l jS F Y’);
#output: 5:45pm on Saturday 24th March 2012
?>