RE: [PHP] Formating datevariables...
| From: | John Holmes | Date: | Tue, 23 Jul 2002 01:32:12 +0000 |
| Subject: | RE: [PHP] Formating datevariables... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-108996@lists.php.net to get a copy of this message | ||
> 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...