Online PHP editor | refs for W6oO5

<?php $result = mysql_query("SELECT `datetime` FROM `table`"); $row = mysql_fetch_row($result); $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 \o\n l jS F Y'); #output: 5:45pm on Saturday 24th March 2012 ?>