note 53676 added to function.date

The following function makes it easy for you to format mysql datetime and timestamp functions with a call of a function. This can be achieved with minimal coding as shown below. 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"); ------------ function mysql_timestamp($stamp, $format) { $pattern = "/^(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})$/i"; if(preg_match($pattern, $stamp, $st) && checkdate($st[2], $st[3], $st[1])) { return date($format, mktime($st[4], $st[5], $st[6], $st[2], $st[3], $st[1])); } return $stamp; } function mysql_datetime($datetime, $format) { $pattern = "/^(\d{4})-(\d{2})-(\d{2})\s+(\d{2}):(\d{2}):(\d{2})$/i"; if(preg_match($pattern, $datetime, $dt) && checkdate($dt[2], $dt[3], $dt[1])) { return date($format, mktime($dt[4], $dt[5], $dt[6], $dt[2], $dt[3], $dt[1])); } return $datetime; } ------------ Enjoy Sunil Amber http://jformmail.sourceforge.net/ ---- Manual Page -- http://www.php.net/manual/en/function.date.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+53676 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+53676&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+53676&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+53676&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+53676&report=yes&reason=useless Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+53676&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+53676&report=yes Search -- http://master.php.net/manage/user-notes.php