note 107757 added to datetime.format

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 = 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 ?> ---- Server IP: 69.147.83.197 Probable Submitter: 59.167.222.68 ---- Manual Page -- http://www.php.net/manual/en/datetime.format.php Edit -- https://master.php.net/note/edit/107757 Del: integrated -- https://master.php.net/note/delete/107757/integrated Del: useless -- https://master.php.net/note/delete/107757/useless Del: bad code -- https://master.php.net/note/delete/107757/bad+code Del: spam -- https://master.php.net/note/delete/107757/spam Del: non-english -- https://master.php.net/note/delete/107757/non-english Del: in docs -- https://master.php.net/note/delete/107757/in+docs Del: other reasons-- https://master.php.net/note/delete/107757 Reject -- https://master.php.net/note/reject/107757 Search -- https://master.php.net/manage/user-notes.php