RE: [PHP-DEV] MySQL Timestamp

SELECT DATE_FORMAT(field_name, \"%m\\%d\\%Y\") AS date FROM table_name Try php3@lists.php.net in the future, as this list is primarily for developers of php. php3@lists.php.net will have faster more complete responses. I believe the DATA_FORMAT() function in MySQL is what you are looking for. Robert Zwink -----Original Message----- From: Mohd Ikhwan (Mahen) [mailto:ikhwan@tas.com.my] Sent: Monday, February 28, 2000 11:17 PM To: php-dev@lists.php.net Subject: [PHP-DEV] MySQL Timestamp How do we format the MySQL timestamp field to be shown on a webpage, as i view the content of the field, it is a numeric value how do we go about converting it.