> > I have a field in my mysql db wich is a timestamp with the format > > yyyymmddhhmmss > > and I would like to display it like: > > dd/mm/yyyy > 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 Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php