> 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

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

Reply via email to