> I have a column in a mysql table with a timestamp. The value of this > column > is for instance: > > 20020722185242 > > How do i change the format on this to "DDMMYYYY" (22072002) in php?
SELECT DATE_FORMAT(date_column,'%d%m%Y') AS Formatted_Date FROM your_table There's no need to involve PHP at all... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
