note 53819 deleted from function.date by nlopess

Note Submitter: dancmdan at yahoo dot com ---- 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"]; ------------