www.php.net/date will show you all the possibilities of formatting the date
bastien
Date: Sat, 22 Dec 2007 17:54:07 +0600
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] date format problem
my problem is with date format
I have a field in my mysql db wich is a timestamp with the format
mmddhhmmss
and I would like to display it like:
dd/mm/
http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1333
SELECT DATE_FORMAT(timestamp_col_name, '%d/%m/%Y') FROM table_name
--
PHP Database