note 53819 added to function.date

I think you can get the same resul like Sunil Amber (sunil_ssm) with date_format function of mysql . Sunil code Pdeudo Code ------------ $result = mysql_query("SELECT datetime, timestamp FROM log WHERE log_id = 1", $conn); $rs = mysql_fetch_array($result); //e.g: 31-12-2005 $formatted_datetime = mysql_datetime($rs["datetime"],"d-m-Y"); //e.g: Sun, 31 December 2005 $formatted_timestamp = mysql_timestamp($rs["datetime"],"D,j F Y"); ------------ Just modify your query like this Pdeudo Code ------------ $result = mysql_query("SELECT date_format(datetime,'%d-%m-%Y') as formatted_datetime, date_format(timestamp,'%a,%e %M %Y') as formatted_timestamp FROM log WHERE log_id = 1", $conn); $rs = mysql_fetch_array($result); //e.g: 31-12-2005 $formatted_datetime = $rs["formatted_datetime"]; //e.g: Sun, 31 December 2005 $formatted_timestamp = $rs["formatted_timestamp"]; ------------ ---- Manual Page -- http://www.php.net/manual/en/function.date.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+53819 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+53819&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+53819&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+53819&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+53819&report=yes&reason=useless Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+53819&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+53819&report=yes Search -- http://master.php.net/manage/user-notes.php